Assistance with Formula- Current Phase

Erika T.

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!

Kelly Moore

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

Erika T.

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!

Kelly Moore

Hey @Erika T.

Is it possible to share a screenshot of your formula - I would like to see the formula including the colored text

Erika T.

Here is the screenshot of the formula itself, thank you!

Kelly Moore

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.

Erika T.

@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!!!