Why is my formula unparseable?
NBKD
✭✭
=IFERROR(COLLECT([Completed Date] - [LTP Conversion Date], AND(IFERROR(MONTH(@cell), 0) = Feb84, IFERROR(YEAR(@cell) = 2023, 0)), {CAD Support Type TD}, ="Long Term Project")), "N/A")
The bold is what I want to subtract within the formula.
Answers
-
You need either a row number or "@row" reference after the first two cell references, and you have one too many closing parenthesis after "Long Term Project". What exactly are you trying to accomplish with your formula?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 458 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 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!