Need a formula to fill in a column based on a date column

Katherine Camacho

Hi! I have a date column and i would like a forumla in another column to complete that cell with the word "completed" when the date is added. Im creating an exterior report that i want to show just the info for the completed rows but the only way we know its completed is by this date being added. If the date column is blank i want the formula column to be blank as well.

I thought it would be an IF formula but im missing something once i select the column on how to finish the formula. Help?

=IF([Date Backup Sent Back]@row, Completed, "")

Mike Wilday

Try this one:

=IF(ISDATE([Date Backup Sent Back]@row), "Completed", "")

For more on ISDATE see:

https://help.smartsheet.com/function/isdate