Formula to display Planned Progress % in reference to Actual Progress %
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!
Best Answer
Answers
-
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
-
@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))
-
@che.rabajante This formula is showing incorrect argument.
-
Hello @Vivien Chong
Please adjust the syntax from using commas (
,
) to semi-colons (;
) in Smartsheet formulas to align with regional preferences.Thanks!
che
-
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.
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!