Setting Up If Statement with 3 Parts
I have a status column where I want the 3 options to be "Not Started, Work in Progress, or Complete". The "Not Started" status would come from the Comments & Date Closed column being blank. The "Work in Progress" status would be based on there being comments added, but the Date Closed has not been filled in. The "Completed" status would need to come from the Date Closed column being filled in.
I have not been able to set up a formula that takes into account both columns and returns the correct status. Could someone help me with this?
Best Answer
-
Try something like
=IF(ISBLANK(Comments@row), "Not Started", IF(ISBLANK([Date Closed]@row), "In Progress", "Completed"))
Answers
-
Try something like
=IF(ISBLANK(Comments@row), "Not Started", IF(ISBLANK([Date Closed]@row), "In Progress", "Completed"))
-
That worked! Thank you for your help, Adam!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!