Welcome!

Score Formula

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.

Healthcare

Formulas

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

Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Formula Error multiple criteria
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…