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?
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.
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
I need a formula that will count the day that a row is "Open" but stop counting the days once its "Closed" both instances need to display the count. Here is a formula I was trying to use. Thanks =IF([Date Closed]@row > 0, ([Date Closed]@row - [Date Opened]@row), TODAY() - [Date Opened]@row)
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.