Trying to Combine a Workday Formula with a Checklist (IF) formula
Hello, see screenshot below. Trying to make a formula to calculate the Due Date 15 days prior to the Date column if the L column is checked. This is what I have so far. All attempts are either coming back to #Date Expected result or #invalidoperation:
=IF(L@row = 1, "Yes", "No") = WORKDAY(Date@row, -15)
Answers
-
Your syntax is not correct and the errors are caused by different things. I'm suprised it's not throwing you an #UNPARSABLE.
For syntax details you can read here . But the "Yes", "No") part should make the = WORKDAY part not run at all.
#DATE EXPECTED is related to the formula syntax issue - in your screenshot, the L@row is checked (aka it = 1) so the formula is putting Yes into the date column.
#INVALID DATA TYPE is likely related to the Date@row being blank.
Try this..
=IFERROR(IF(L@row = 1, Date@row - 15), "TBD")
It will leave the Due Date blank where the L@ row is not checked, and it will give you 15 calendar days prior to the Date@row column when that is populated. Where Date@row is blank and L@row is checked it should return TBD.Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| business optimization product manager
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!