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
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives