Conditional Formula

JBrenier

What is the formula to use if I was to populate a value in one column if the Start date is today's date or later?  Is this possible?  So if the start date is todays date (for example) I would like the status column to change from a value of Planned to Current.  Any ideas?

Andrée Starå

Hi,

Try something like this.

What do you want it to show if there isn't a date?

=IF(Date@row >= TODAY(); "Current"; "Planned")

The same version but with the below changes for your and others convenience.

=IF(Date@row >= TODAY(), "Current", "Planned")

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD