IFERROR within a formula
Any help would be great
I thought this would be simple, but it isn't working.
Original formula:
=WORKDAY([Production Begins]@row, +[1st Proof Lead Time]@row, {Holidays Range 3}) provides a date in the column.
Formula with IFERROR added:
=IFERROR(WORKDAY([Production Begins]@row, +[1st Proof Lead Time]@row, {Holidays Range 3}), “”) this results in an unparseable error.
Answers
-
See your quotes? They are slanted.
Look at these quotes...
" "
They aren't.
The slanted quotes are called "Smart Quotes" which (ironically enough) Smartsheet doesn't recognize. Try retyping it either in Smartsheet directly, here in the Community, or in a text editor such as Notepad (not Word).
-
@Paul Newcome Awesome I had copied and pasted this in from Word instead of typing it directly. Ah another lesson learned. This could have been my issues with other formulas I had been having issues with. Deleted and retyped it works perfectly,
Thank You
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!