3 values from 2 dates

I have 3 date-related fields; created on, started on, and completed on in a table. With these dates, I want to assign the status (backlog, in progress, completed) with this logic to a column;

if ‘created on’ exists and ifblank( started on ) then “backlog”
if today() > ‘started on’ and ifblank( ‘completed on’) then “in progress”
if ‘completed on’ exists then “completed”

What formula will do this?
Thanks in advance!


Here’s one approach.

1 Like

Thank you very much!

This tip really helps!

1 Like