Formula to display Planned Progress % in reference to Actual Progress %

Vivien Chong

For the Actual Progress %, we are using this formula to surface the latest number:

=MAX([Actual Progress %]:[Actual Progress %])

However for the Planned Progress %, I use the following formula and it is showing no match:

=INDEX([Planned Progress %]:[Planned Progress %], MATCH(MAX([Actual Progress %]:[Actual Progress %]), 1))

Appreciate help!

Find more posts tagged with

Accepted answers

che.rabajante

Hello @Vivien Chong

You forgot to input the closing parenthesis

All comments

che.rabajante

Hello @Vivien Chong

Here's the solution if referencing the Actual Progress % (This works only if you have Parent & Child row relationship).

Here's also simplified formula for Actual Progress % (This works only if you have Parent & Child row relationship)

Hope this helps!

Che

Vivien Chong

@che.rabajante Thanks for your advice.

I tried the formula you showed in the parent row of Planned Progress % as follows, but it is showing incorrect argument.

=INDEX(COLLECT(CHILDREN(), CHILDREN([Actual Progress %]@row, [Actual Progress %]@row), 1))

Vivien Chong

@che.rabajante This formula is showing incorrect argument.

Screenshot 2023-12-26 at 10.51.38 AM.png

Screenshot 2023-12-26 at 10.52.31 AM.png

che.rabajante

Hello @Vivien Chong

Please adjust the syntax from using commas (,) to semi-colons (;) in Smartsheet formulas to align with regional preferences.

Thanks!

che

Vivien Chong

Hi @che.rabajante which of the following comma should be changed to semi colons?

=INDEX(COLLECT(CHILDREN(), CHILDREN([Actual Progress %]@row, [Actual Progress %]@row), 1))

So far, I have not come across any semi colons in Smartsheet formula before.

che.rabajante

Hello @Vivien Chong

You forgot to input the closing parenthesis

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.