Question/Help with IF Statements

Hello,

I'm working on a sheet for new employees and I'm trying to build a simple IF statement that will display whether or not the employee started, based on today's date.

=IF([Start Date]@row = TODAY, "Yes"), IF([Start Date]@row = >TODAY, "No")))

I must be doing something wrong. Do I need rearrange the formula? I'm trying to avoid having to add a new column, instead of just having this IF statement work.

-Andrew

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!