Why is my multiplication formula invalid?
I am trying to create a column that multiplies the total hours by the pay rate of certain staff.
In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55", IF(Name1 = "Stephen", "55")))
This formula works well, however if I then try to use those values in another formula is just says "#INVALID OPERATION"
Please help!
Best Answer

Try removing quotes around numbers. with the quotes, Smartsheet see values as text instead of numbers.
Or add the VALUE function to your other formula so those values are treated as numbers.
Hope it helped!
Answers

Try removing quotes around numbers. with the quotes, Smartsheet see values as text instead of numbers.
Or add the VALUE function to your other formula so those values are treated as numbers.
Hope it helped!
Help Article Resources
Categories
Check out the Formula Handbook template!