If Formula Help

Options
Nathan Umbriac
Nathan Umbriac ✭✭✭✭✭
edited 10/28/20 in Smartsheet Basics

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!

Answers