IF and AND
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete")
I would like to know if it is possible to pull out the information from the column instead of a "text"
i.e:
=IF(AND({5S Audit Score Entry Range 5}=[Cell Name]@row1,{5S Audit Score Entry Range 6}="4", {5S Audit Score Entry Range 7}
Thanks,
Ana Thomaz
Answers
-
Hi @Ana Thomaz
Hope you are fine, it is possible to pull out the information from the column instead of a "text", if you supply a screenshot for your sheet ( remove any sensitive data ) i can write the complete formula for you.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @Ana Thomaz
You can pull out info from columns, obviously, but you cannot check if a range is equal a specific cell like in your example. This won't work.
For example, your first example could be written like this:
=IF(COUNT([Status]:[Status])=COUNTIFS([Status]:[Status], "Complete"), "All tasks are complete")
But this wouldn't work:
=IF([Status]:[Status]="Complete", "All tasks are complete")
Hope it helped!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives