Index Collect Formula for Dates resulting in Invalid Value Error
Answers
-
I follow what you're saying. I added a helper column to the source sheet with the VALUE formula to ensure the project number is converted to a number data type. I also updated my formula on the target sheet to reference the helper column. It worked. All of the dates I'm expecting to see are showing up properly now.
Thank you so much!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 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!