IF AND formula with multiple arguments

Andy F

Hi

I am trying (very badly) to write the following formula to the Project Status column

• "Ontime" if actual start matches or precedes planned start and planned end is not passed
• "At Risk" if actual start is after planned start and planned end is not passed
• "Late" if planned end date has passed and actual end date is blank

I got this far but don't think I am close.

=IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time", IF([Actual Start Date]@row > [Planned Start Date]@row), "At Risk", =IF(TODAY() > [Due Date]1, “Past Due”)

Appreciate any pointers.

Andy

Intern98

=IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time", IF([Actual Start Date]@row > [Planned Start Date]@row), "At Risk", =IF(TODAY() > [Due Date]@row, “Past Due”))

Andy F

Hi Intern98

Did not seem to work. I changed the last argument as had incorrect column name

=IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time", IF([Actual Start Date]@row > [Planned Start Date]@row), "At Risk", =IF(TODAY() > [Planned End Date]@row, “Late”))

Andrée Starå

Hi @Andy F

I hope you're well and safe!

Try something like this.

=
IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time", 
IF([Actual Start Date]@row > [Planned Start Date]@row), "At Risk", 
IF(TODAY() > [Planned End Date]@row, “Late”)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andy F

Hi @Andrée Starå

Thanks for addressing.

Each argument works in isolation in the column but when assembled together returns UNPARSEABLE

=IF([Actual Start Date]@row <= ([Planned Start Date]@row), "On Time"), IF([Actual Start Date]@row > [Planned Start Date]@row, "At Risk"), IF(TODAY() > [Planned End Date]@row, "Late")

Bit stuck now.

Andy