Workday Formula
Hi All,
Not sure what I am doing wrong here, but the Workday formula does not seem to work when selecting multiple holidays and results in "#INVALID DATA" error. The formula works if I just select one bank holiday but errors with multiple. I have attached a screenshot - any help gratefully received!
Georgina
Best Answer
-
Make sure all of the bank holiday columns are formatted as date type columns. Also make sure that the values within those cells are actual dates and not text strings that just look like dates.
Answers
-
Make sure all of the bank holiday columns are formatted as date type columns. Also make sure that the values within those cells are actual dates and not text strings that just look like dates.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!