Calculate % Complete based on values in 2 columns

shannons_5

I'm trying to determine what the % complete is based on the data in both of those columns. First # is the target to complete, the Second # is how many are complete.

Ryan Sides

@shannons_5

Hi Shannon!

try this one: = [Reporting In]@row / [To Collect]@row

Then you can format your %Complete column as a percentage.

Please let me know if that's what you were going after.

Ryan

Ryan Sides

@shannons_5

Hi Shannon!

try this one: = [Reporting In]@row / [To Collect]@row

Then you can format your %Complete column as a percentage.

Please let me know if that's what you were going after.

Ryan

shannons_5

Thank you Ryan! That was super simple and it worked perfectly.

Ryan Sides

@shannons_5 #boom! I love waking up to helping people 😁 Have a great one!