substrate a cell from another cell -> error
Hi Experts,
I try to do a simple substation, but I always get the error (Invalid operation).
I would like to get the result 1,5 - 3= -1,5
But I have the feeling that 1,5 is not identified as a number.
The formula in column "Treshhold TBD" is like this
=IF([Dev Type]@row = "NM", "1,5", IF(OR([Dev Type]@row = "EM", [Dev Type]@row = "NT", [Dev Type]@row = "TN", [Dev Type]@row = "TD"), "7,5", ""))
How can I fix it? Thanks
Best Answer
-
Hello @Christine Menke
When numbers are enclosed in quotes, smartsheet may mistakenly treat the value as text rather than as a number. Remove quotes from around the numbers.
=IF([Dev Type]@row = "NM", 1,5, IF(OR([Dev Type]@row = "EM", [Dev Type]@row = "NT", [Dev Type]@row = "TN", [Dev Type]@row = "TD"), 7,5, ""))
Kelly
Answers
-
Hello @Christine Menke
When numbers are enclosed in quotes, smartsheet may mistakenly treat the value as text rather than as a number. Remove quotes from around the numbers.
=IF([Dev Type]@row = "NM", 1,5, IF(OR([Dev Type]@row = "EM", [Dev Type]@row = "NT", [Dev Type]@row = "TN", [Dev Type]@row = "TD"), 7,5, ""))
Kelly
-
Thanks @Kelly Moore it works!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!