how to make decimals work?
Hi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example:
=IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01)
how can i multply with decimals?
Thanks
Answers
-
Try using a comma instead of a semi-colon
;
=IF([KPI ASIGNACIÓN DE OBRA]4 > 3, ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01)
-
Unfortunately the syntax is differemt depending on wich language you are using smartsheet so in spanish yo have to use semi colon instead of commas in order to make formulas work.
-
This seems to work for me, which really isn't changing much from (if any) from what you have already had. Are you typing the column names or are you clicking within the cell? If typing, try clicking and see if that works.
=IF([KPI ASIGNACIÓN DE OBRA]@row > 3; ([KPI ASIGNACIÓN DE OBRA]@row - 3) * 0.01)
-
Thank you for your help. The problem was that my account had Spain as a region instead of Mexico and somehow that mess up the use of decimals.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives