If Formula Help

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
-
=IF(OR(ISBLANK([Meeting Required]@row), [Meeting Required]@row = "No"), "", IF(AND([Meeting Required]@row = "Yes", [Due Date]@row >= TODAY(30)), "On Time", "Late"))
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives