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), "At Risk", =IF(TODAY() > [Due Date]1, “Past Due”) Appreciate any pointers. Andy

IF AND formula with multiple arguments

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

Find more posts tagged with

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.