What Formula should I use.....?
Lpv_11
✭✭
Hello Team
I need to change the status to Yes when the END DATE has been entered. Or NO, if the date is still blank. So, if the date was entered, the status will change to YES; if it is not, the status will be NO.
Please see attached.
Thank you again for your help!
Best Answer
-
if(isblank([End Date]@row),"No","Yes")
Answers
-
if(isblank([End Date]@row),"No","Yes")
-
Hello @Lpv_11
To add to @markkrebs answer, I would make the column a column formula column.
Right click on the Yes/No column and scroll to the bottom and select Convert to Column Formula
-
OH MY GOD! IT Worked!! Thank you so so much! :)
-
Yes - always use column formulas when possible
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!