Formulas not adding as numbers
Hello,
I am using the formula =IF(Status2 = [HIDE: Statuses]1, "15") to add a set percentage to a completed task when the box is checked. It works, but then when I go to SUM those numbers, they simply combine the numbers (as though they're text) rather than adding them together (see %Complete1 and %Complete4). How do I make the SUM formula recognize these as numbers?
Thanks!
Laura
Tags:
Comments


ahhh  too easy!! Thank you so much!

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!