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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 378 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 289 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!