Multiplication of a number and the result of a formula
Hello,
I'm trying to multiply a number and the result of a formula (also a number) but it says "INVALID OPERATION", any ideas please.
Thank you
Best Answer
-
Hi @Jlind
It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?
Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:
=Volume@row * VALUE([Baselined?]@row)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
Hey @Jlind
Is it possible to share your formulas (both of them)? It is almost impossible without more information for the community to guess what might be causing your error. Also a screenshot of your sheet is always helpful (and usually helps get faster response from the community).
With the additional info someone from the community will be glad to help.
Kelly
-
Sure,
Please see below, the number is the first column and the formula is the second column.
-
Hi @Jlind
It looks like the [Baselined?] column is turning your 1 and 0s into Text, see how they're appearing at the LEFT side of the cell instead of the right?
Try wrapping this cell reference in a VALUE function to turn it into a number again, like so:
=Volume@row * VALUE([Baselined?]@row)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 438 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 283 Events
- 33 Webinars
- 7.3K Forum Archives