If Formula Help

Nathan Umbriac

Hello,

I spent some time with Pro Desk this morning, but we couldn't figure out the right formula for what I'm trying to accomplish.

It is an IF(AND formula, where if data in a certain cell is "No", the result will display "Not applicable." Easy enough: =IF([Meeting Required]@row = "No", "Not applicable"

Now the complicated part with the continuation of the formula. If that certain cell has "Yes," then I want the formula to look at a date column. If the date>= 30 calendar days from the another column date field [Due Date], I want it to display "On Time." If the date is <30 days, I want it to display "Late."

Currently, I have: =IF([Meeting Required]@row = "No", "Not applicable", IF([ Meeting Required]@row = "Yes", IF(AND([Date Helper Column]@row >= 30, "On Time", "Late")))), but I'm getting #INCORRECT ARGUMENT SET.

I was told to create this 'helper column' to calculate the date between the two dates, then just reference that.

Any help would be appreciated. Thanks!

Nic Larsen

=IF(OR(ISBLANK([Meeting Required]@row), [Meeting Required]@row = "No"), "", IF(AND([Meeting Required]@row = "Yes", [Due Date]@row >= TODAY(30)), "On Time", "Late"))

Nathan Umbriac

Thanks Nic, this is almost correct. The calculation at the end of the statement in my formula references a 'helper cell' that calculates the number of days between two dates.