Need Help with UNPARSABLE ERROR and BLOCKED Formula error
I need a Date (the Actual End Date) in the Description Column Row 35.when the Task cell equals the task of current row. and if no date in that cell to be blank Current formula is
=IFERROR(DATEONLY(INDEX(COLLECT([Actual End Date]59:[Actual End Date]354, [Summary Formula Helper]59:[Summary Formula Helper]354, 1, Task59:Task354, Task35), 1, 1)), " ") + ""
Tags:
Best Answer
-
Hey @Danielle Maroon
The current formula you posted is not the current formula in your sheet. Your sheet shows one last parenthesis. Remove that
Kelly
Answers
-
Hey @Danielle Maroon
The current formula you posted is not the current formula in your sheet. Your sheet shows one last parenthesis. Remove that
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 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!