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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!