Help with Long IF,AND,OR formula
Hi,
Needing some help with the below formula. Everything is working correctly but the last IF/AND/OR statement and can't figure out what I'm missing. Any help is greatly apricated.
=IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = true, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = true))), "Reconnect Needed", IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = false, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = false))), "Reconnected", IF(AND([Water Disconnected]@row = true, OR([Water Meter #]@row = "NO Meter"), OR([Electric Disconnected]@row = true), "Disconnected", ""))))
Answers

It appears you're missing one ending parenthesis for the last AND() statement right before "Disconnected", and also have one extra closing parenthesis for the three IF() statements that needs to be removed. Try this:
=IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = true, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = true))), "Reconnect Needed", IF(AND([Payment Received]@row = true, OR([Water Disconnected]@row = false, AND([Water Meter #]@row = "NO Meter", [Electric Disconnected]@row = false))), "Reconnected", IF(AND([Water Disconnected]@row = true, OR([Water Meter #]@row = "NO Meter"), OR([Electric Disconnected]@row = true)), "Disconnected", "")))
Renée Roberge
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 455 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!