Calculate % Complete based on values in 2 columns

shannons_5

shannons_5 ✭

10/20/22 in Formulas and Functions

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.

0 ·

Best Answer

Ryan Sides ✭✭✭✭✭✭

10/20/22 Answer ✓

@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
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · Share on Facebook Share on Twitter

Answers

Ryan Sides ✭✭✭✭✭✭

10/20/22 Answer ✓

@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
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · Share on Facebook Share on Twitter
shannons_5 ✭

10/20/22

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

0 · Share on Facebook Share on Twitter
Ryan Sides ✭✭✭✭✭✭

10/21/22

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

Ryan Sides
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How can I get the column to accurately track hours elapsed?
Hello! Trying to have Total Time calculate total hours elapsed from Start Time to End Time. I created "helper" columns based on another question's answer, but it didn't help. We use 24-hour clock here and I need the column formula to consider that some values will start before midnight and end after midnight and will…
Formula Help
I think this should be a simple formula but I am getting a circular reference error. Can someone help? When the DocuSign status is sent then I would like the status column to change to "Pending Sig. Approval" =IF([DocuSign Status]@row = "Sent", "Pending Sig. Approval", [Status]@row)
Use Contain with And extension?
Hi, I'm trying to pull the correct tuition rate based on MS/M.S. or PhD status and if their department contains Engineering. This is my Active sheet. The formula I'm currently using: =IF(CONTAINS("Engineering", [Grad Field of Instruction]@row), 14750, 10400). So I thought adding the ADD Degree Program = M.S. MS, but unsure…