Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
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
Hello everyone, I'm building an automated Above Ceiling Work Permit process for our hospital and have almost everything working. I'm hoping someone can tell me if the final step is possible using native Smartsheet features. My current workflow A contractor scans a QR code and completes a Smartsheet Form. The form creates a…
I am using the new "linked" column for a dropdown on my sheet. Is there any way to sort the dropdown options? I have sorted them on my source sheet, however it doesn't update in the dropdown.
I am building out my sheet summary from a schedule. I have a Parent Row column and all of my parent rows have a checkbox. I want a formula that looks at the first checkbox and looks at the status. If status is Complete, that summary field would then indicate that the Project is in Definition. If the status is In Progress…
