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!