Formula help...can this be done?

Loann McGee

Column A is a date column. Column B tells us if we have scheduled Column A so it will sort into the right report.

The formula in Column B needs to state that if Column A is a date, then the value is YES; If Column A says "Not Scheduled" it is No. Otherwise, Column B will remain blank.

 

Can that be done?

 

Blessings,

Loann

Greg Gates

Absolutely! There's a really handy "ISDATE" formula that can help us with this (see http://help.smartsheet.com/articles/775363-using-formulas#logic):

 

=IF(ISDATE([Column A]1), "YES", IF([Column A]1 = "Not Scheduled", "NO", ""))

 

Basically, we have two steps:

1) If the value in Column A is any date, set this cell to "YES." Otherwise, go to step 2.

2) If the value in Column A is "Not Scheduled" (capitalization doesn't matter, but spelling does), then set this cell to "NO." If neither of these conditions were met, leave the cell blank.

 

I hope that addresses your question! Let me know if something needs to be changed.