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
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!