I've created a scorecard in smartsheet and want to create a formula that does not allow the scorecard score to show as more than 100%.
I think is should be something like If score >100%,100%
but am not sure what the entire formula should be.
Hi Learle,
The numbers have to be formatted like 1 (for 100%) 0,5 or 0.5 (for 50%, depending on your region) for percent.
Try this.
=IF(Score@row >= 1; 1)
The same version but with the below changes for your and others convenience.
=IF(Score@row >= 1, 1)
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Did it work?
Happy Holidays & Happy New Year!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I would suggest using the "else" portion of the IF statement as well in case the score is less than or equal to 100%. Something along the lines of...
=IF(Score@row >= 1, 1, Score@row)
Paul,
Yes, that's a must. Thanks!
No worries. I often forget to plug that part in and then get frustrated when my formulas aren't working the way they are supposed to. Hahaha
I have a sheet accessed by monkeys users who keep managing to muck up a currency column. They are either pasting in amounts from some other source or literally typing in the dollar sign followed by a number, or something. The result is reports that lose their currency formatting. Smartsheet seems to treat these bad entries…
Hi my colleague has imported an Excel spreadsheet and one of the formulas hasn't worked on import. Please could someone let me know if the following Excel formula can be converted into a usable Smartsheet formula? Here it is: =IF(B4<>"", ROW()-1, "") Many thanks, Lee
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
