I need with an if then type of formula please!
Still new to Smartsheet formulas. For specific rows in my Smartsheet; If column A has any date at all in it, then I want to populate column B with the text "Completed". Thanks!
Best Answers
-
Close! You just need the column name itself in there.
=IF(ISDATE(Finish@row), "Completed", "")
If your column name includes a number at the end, or is more than one word, that's when you enclose it in brackets:
=IF(ISDATE([Finish123]@row), "Completed", "")
=IF(ISDATE([Finish Date]@row), "Completed", "")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Jeff, thanks so much! I can't wait to have time to learn more about using Smartsheet! :)
Answers
-
There's a function for that! ISDATE evaluates if a value is a date. Put this in Column B:
=IF(ISDATE([Column A]@row), "Completed", "")
In English: If Column A is a date value, set this column to "Completed", otherwise leave it blank (the empty quotes.)
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Jeff, thank you for your quick response! So, in my Smartsheet, what I above refered to as Column A is actually a column names (Finish), would this be the correct text to inter?
=IF(ISDATE([Column Finish]@row), "Completed", "")
-
Close! You just need the column name itself in there.
=IF(ISDATE(Finish@row), "Completed", "")
If your column name includes a number at the end, or is more than one word, that's when you enclose it in brackets:
=IF(ISDATE([Finish123]@row), "Completed", "")
=IF(ISDATE([Finish Date]@row), "Completed", "")
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Jeff, thanks so much! I can't wait to have time to learn more about using Smartsheet! :)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!