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 seen this question asked multiple times in the forum, but I couldn't find any clear answer provided in the answers. Please excuse me if a solution already exists, but if not, will someone please let me know if it is possible to use a previous cell value (from cell history) in a formula? I am specifically trying to…
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!
