Assistance with Formula- Current Phase
I would like to highlight the stage that my project is currently in. I have been using the following formula but continue to get a #unparseable and not sure what I might be missing.
My formula is: =INDEX(COLLECT([Task Name]:[Task Name], [% Complete]:[% Complete], @cell < 1, Ancestors:Ancestors, @cell = 2), 1, 1)
Any help is greatly appreciated, thanks!
Answers
-
Hey @Erika T.
The formula posted above as an extra set of ",1". Remove one of them
=INDEX(COLLECT([Task Name]:[Task Name], [% Complete]:[% Complete], @cell < 1, Ancestors:Ancestors, @cell = 2), 1)
Will this work for you?
Kelly
-
Hey @Kelly Moore ,
I removed the 1 and I continue to get the same error. The perplexing part is I am pulling it from another project plan I have. So not sure why the difference/error.
Thank you! I am open to any other suggestions!
-
Hey @Erika T.
Is it possible to share a screenshot of your formula - I would like to see the formula including the colored text
-
Here is the screenshot of the formula itself, thank you!
-
Hey @Erika T.
Notice how your column names are not colored. This indicates that smartsheet is not matching the names of one or more of the columns to your sheet, or there is are error with the brackets. I don't see a bracket error so please check your column names. I would suggest, one by one, erasing the names from your formula and clicking into a cell then erasing the @row/row number from the name. This will give you the exact spelling.
-
@Kelly Moore My peer helped me figure it out, I was missing a column for Ancestors to be able to make it work. After we investigated, we now got it to work.
Thank you again for your help!!! You are amazing!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!