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!

che.rabajante

Hello @Vivien Chong

You forgot to input the closing parenthesis

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.

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