How to subtract percentages?

Options
v.winters
v.winters ✭✭
edited 06/28/23 in Formulas and Functions

I created a new column % Not complete and am trying to add a formula to have =100%-[%Complete]@row. Answer #UNPARSEABLE

I have also tried =100-%Complete]@row. Answer: This will populate an answer, however I cannot adjust the formatting from % to number


Example:

%Complete = 13%

Correct answer should display 87%


Second option displays 9,987%



I adjusted the value from 100 to 1 and it works! Hopefully this helps others too :)

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!