Formula to Return 3 Different Answers Based On Cell Value
Hello,
I am trying to create a formula that returns 1 of 3 answers based on the value of the selected cell. Right now I have it set up to show me Complete/Incomplete based on the number 4 being in a column, but it would be more useful for me to see "In Progress" for cells that have a 1, 2, or 3 in them. My current formula is =IF([Count IF Functions]1 = "4", "Complete", "Incomplete")
Any tips on how to achieve this would be appreciated! :)
0="Incomplete"
1-3="In progress"
4="Complete"
Best Answer
-
You are on the right track, you just need to nest some IF functions. Try this:
=IF([Count IF Functions]@row = 4, "Complete", IF(AND([Count IF Functions]@row < 4, [Count IF Functions]@row > 0), "In Progress", "Incomplete"))
Answers
-
You are on the right track, you just need to nest some IF functions. Try this:
=IF([Count IF Functions]@row = 4, "Complete", IF(AND([Count IF Functions]@row < 4, [Count IF Functions]@row > 0), "In Progress", "Incomplete"))
-
Thank you! That was exactly what I wanted, it worked beautifully! 😀
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!