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
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives