I need with an if then type of formula please!

Brenda S

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!

Jeff Reisman

@Brenda S

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", "")

Brenda S

Jeff, thanks so much! I can't wait to have time to learn more about using Smartsheet! :)

Jeff Reisman

@Brenda S

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.)

Brenda S

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", "")

Jeff Reisman

@Brenda S

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", "")

Brenda S

Jeff, thanks so much! I can't wait to have time to learn more about using Smartsheet! :)