Returning txt in one cell depending on multiple check boxs with IF & AND
Hi,
I'm trying to use IF & AND statements to return text to one cell depending on the condition of multiple check boxes. I have searched through the community posts and can't find the answer. Any help would be greatly appreciated. Below is what I have so that can't get to work.
=IF(AND([Electric Disconnected]@row = 1, "Disconnect Water", IF([Water Disconnected]@row = 1,"Disconnect Electric", IF(AND([Electric Disconnected]@row=1,[Water Disconnected]@row=1),"Disconnect Complete",[""]))))
Best Answer
-
The square brackets [ ] are used in Smartsheet to indicate column names, so that is returning an error in your formula. I'd also adjust the logic to check for both disconnections first, otherwise it would never return "Disconnect Complete" (because when "Electric Disconnected" returns true, the formula stops, and doesn't go to the next false statement).
=IF(AND([Electric Disconnected]@row = 1, [Water Disconnected]@row = 1), "Disconnect Complete", IF([Electric Disconnected]@row = 1, "Disconnect Water", IF([Water Disconnected]@row = 1, "Disconnect Electric", "")))
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
Answers
-
Update sorry for some reason I had IF and at the beginning.
=IF([Electric Disconnected]@row = 1, "Disconnect Water", IF([Water Disconnected]@row = 1,"Disconnect Electric", IF(AND([Electric Disconnected]@row=1,[Water Disconnected]@row=1),"Disconnect Complete",[""]))))
-
The square brackets [ ] are used in Smartsheet to indicate column names, so that is returning an error in your formula. I'd also adjust the logic to check for both disconnections first, otherwise it would never return "Disconnect Complete" (because when "Electric Disconnected" returns true, the formula stops, and doesn't go to the next false statement).
=IF(AND([Electric Disconnected]@row = 1, [Water Disconnected]@row = 1), "Disconnect Complete", IF([Electric Disconnected]@row = 1, "Disconnect Water", IF([Water Disconnected]@row = 1, "Disconnect Electric", "")))
Jason Tarpinian - Sevan Technology
Smartsheet Aligned Partner
-
Thanks that worked!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 489 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives