Round and % formulae
Gaurav Chauhan
✭✭✭✭✭✭
Hi
Can you please check this formulae below. I need to round up the value to 2 digits and add %
=INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1)
Currently the value output is 41.395
Expected results is 41.39%
Answers
-
Does this work?
=ROUNDDOWN(INDEX(COLLECT({Profit Margin}, {Program Name}, CONTAINS([Program Name]@row, @cell)), 1),2)+"%"
-
Hi, thank you for the help.. But adding ROUNDDOWN leads to INVALID
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!