Without using Project settings/working days, (If date is a holiday, then.....) formula
This isn't working for me. I have holidays for the next two years in (Date Observed), then I have a series of dates for task or project due dates that can't be due on a holiday. I have this so far and it doesn't work:
=if(or(Date@row=[Date Observed]4,,Date@row=[Date Observed]5,Date@row=[Date Observed]6,,Date@row=[Date Observed]7,Date@row=[Date Observed]8,,Date@row=[Date Observed]9,,Date@row=[Date Observed]10,,Date@row=[Date Observed]11,Date@row=[Date Observed]13,Date@row=[Date Observed]14,Date
@row=[Date Observed]15,Date@row=[Date Observed]16,Date@row=[Date Observed]17,Date@row=[Date Observed]18,Date@row=[Date Observed]19,Date@row=[Date Observed]20,Date@row=[Date Observed]21,Date@row=[Date Observed]22,Date@row=[Date Observed]23,Date@row=[Date Observed]24),Date@row+1,date@row)
Result: #UNPARSEABLE
David L. Reed
Finance Transformation / SOX Advisor
Zeevo Group LLC
701 Fifth Avenue; Floor 42, Seattle, WA 98104 USA
Mobile: +1 253 250 5259
Best Answer
-
I'm assuming you're trying to use this formula in a project schedule. If this is the case and you have Dependencies enabled, you cannot use a formula in either the Start or Finish date columns.
Short of this, I see a few places in your formula where there a double commas without a condition between them.
Answers
-
I'm assuming you're trying to use this formula in a project schedule. If this is the case and you have Dependencies enabled, you cannot use a formula in either the Start or Finish date columns.
Short of this, I see a few places in your formula where there a double commas without a condition between them.
-
Jason,
Thank you very much. the double commas were the issue. It works now, but I am still hoping to see if there is a if index match scenario that I can shorten this in the future
Thanks again,
David
David L. Reed
Finance Transformation / SOX Advisor
Zeevo Group LLC
701 Fifth Avenue; Floor 42, Seattle, WA 98104 USA
Mobile: +1 253 250 5259
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!