Customer Data Hub

Michael Smith

Edit

Personal Info

Full Name
Michael Smith
Phone
772-696-4609
Phone 2
Order ID
recu6jw7LXGFwSnY7
Customer #
612-605-1624

Property Address

Street
903/901 Van White Memorial Blvd
City
Minneapolis
State
MN
Zip
55411

Billing Address

Street
903 Van White Memorial Blvd
City
Minneapolis
State
To extract the StateCode from an address in the format "HouseNumber StreetName, City, StateCode, Zipcode" in the field "903 Van White Memorial Blvd", use this formula: ``` TRIM(MID({903 Van White Memorial Blvd}, FIND(",", {903 Van White Memorial Blvd}, FIND(",", {903 Van White Memorial Blvd})+1)+2, 2)) ``` This will return the two-letter StateCode.
Zip
Zipcode

Office

Office Address
50 S 6th St. Ste1390 Minneapolis, MN 55402

Service Details

Lawn & Snow Customer
No
Auto Renewal Lawn
Auto Renewal Snow
Weed & Feed
Trigger Inch
Salt
Mowing Caution
Service Years
2025 Fall Cleanup, 2026 Spring Cleanup

2026 Renewal Info

Updated # of Mows
Mow Frequency
Lawn Only Renewal
Lawn + Snow Combined
Amount to be Charged

Notes

Office (Lawn)
Office (Snow)
Operator (Lawn)
Operator (Snow)
Cancellation