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
- Smartsheet Customer Resources
- 62.1K Get Help
- 351 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 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!