Need to check and uncheck a box based on a percentage being above 0 and less than 100.
I have been trying different variations of the below but it always errors out until I start checking boxes and when the percentage reaches 100 the box is still checked.
The checkbox in question is in a column named Inprocess, and the percentage in in a column named Percent completed.
=IF([Percent Completed]@row > 0, true, false, IF([Percent Completed]@row < 100, true, false))
Best Answers
-
Nic Larsen ✭✭✭✭✭✭Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))
-
Nic Larsen ✭✭✭✭✭✭
If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column.
If the % complete is greater than 0, check the box (which is a 1 value).
If % complete is zero, it will also be unchecked.
Answers
-
Nic Larsen ✭✭✭✭✭✭
Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))
-
That worked but I am unsure why. Thanks!!
-
Nic Larsen ✭✭✭✭✭✭
If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column.
If the % complete is greater than 0, check the box (which is a 1 value).
If % complete is zero, it will also be unchecked.
Categories
If it is a field that you have to request be updated after a form is submitted, I would suggest creating an automation to send out an update request with the field(s) that need to be filled out. If, however, it's not consistent fields or information, then I would create a report for the submitters to access so they can edit\/add information as needed.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110805,"type":"question","name":"referencing cells","excerpt":"Hello, I have notice anytime I try to reference a column in a formula it doesn't automatically recognizes the name and then I always get the unparseable error. For example in below I want Smartsheet to calculate all the item listed as test under the column implementation Manger. =COUNT(Implementaiton Manager:Implementation…","snippet":"Hello, I have notice anytime I try to reference a column in a formula it doesn't automatically recognizes the name and then I always get the unparseable error. For example in…","categoryID":321,"dateInserted":"2023-09-26T18:14:45+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T19:15:45+00:00","insertUserID":165127,"insertUser":{"userID":165127,"name":"Mkaur","url":"https:\/\/community.smartsheet.com\/profile\/Mkaur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T19:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165127,"lastUser":{"userID":165127,"name":"Mkaur","url":"https:\/\/community.smartsheet.com\/profile\/Mkaur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T19:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3391509030,"url":"https:\/\/community.smartsheet.com\/discussion\/110805\/referencing-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110805\/referencing-cells","format":"Rich","lastPost":{"discussionID":110805,"commentID":397063,"name":"Re: referencing cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/397063#Comment_397063","dateInserted":"2023-09-26T19:15:45+00:00","insertUserID":165127,"insertUser":{"userID":165127,"name":"Mkaur","url":"https:\/\/community.smartsheet.com\/profile\/Mkaur","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-26T19:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-26T19:14:51+00:00","dateAnswered":"2023-09-26T19:14:03+00:00","acceptedAnswers":[{"commentID":397061,"body":"
If the column name contains spaces (is not a single word) you need to place brackets around it:<\/p>
