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
Hi! I am relatively new to Smartsheet and trying to figure out how to program a sheet I am working on. I have one sheet holding many rows, each row representing a different project. For each project, the user is able to mark the priority as high, medium, or low, using the built in Smartsheet symbols. The goal is to make it…
Hello everyone, I am trying to create a cell that calculates the number of times a certain name shows up whenever a criteria is chosen from a dropdown menu. Currently, I have Column E with a dropdown menu of names (uses data from Column L). Column F will use that cell as a reference to populate a cell using VLOOKUP…
All the above rules are working except the 4th one in the list which asks for the cell to turn red if Group status is not started and end date is in next 14 days. I have used the Smartsheet AI tool but no luck, I have saved and refreshed. I am using a helper column for my 5th rule in the list which asks the cell to turn…
