Need to check and uncheck a box based on a percentage being above 0 and less than 100.

SmartSheet Newbie
SmartSheet Newbie ✭
inSmartsheet Basics

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))

· Share on Facebook Share on Twitter

Best Answers

Answers

Categories

Hello @fb_smd<\/a>,<\/p>

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":"

Hi @Mkaur<\/a> ,<\/p>

If the column name contains spaces (is not a single word) you need to place brackets around it:<\/p>

=COUNTIF([<\/strong>Implementation Manager]<\/strong>:[<\/strong>Implementation Manager]<\/strong>, \"test\")<\/p>

Hope this helps!<\/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":110782,"type":"question","name":"Filter By Cell Color","excerpt":"Is there a way to create a filter to only show let's say cells highlighted in yellow?","snippet":"Is there a way to create a filter to only show let's say cells highlighted in yellow?","categoryID":321,"dateInserted":"2023-09-26T14:57:55+00:00","dateUpdated":null,"dateLastComment":"2023-09-26T15:18:32+00:00","insertUserID":140966,"insertUser":{"userID":140966,"name":"DieHard Jets","url":"https:\/\/community.smartsheet.com\/profile\/DieHard%20Jets","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqNr_7IPH7s!7YEoe-ZaUvs!GnmHpUESlnd","dateLastActive":"2023-09-26T15:17:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":140966,"lastUser":{"userID":140966,"name":"DieHard Jets","url":"https:\/\/community.smartsheet.com\/profile\/DieHard%20Jets","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqNr_7IPH7s!7YEoe-ZaUvs!GnmHpUESlnd","dateLastActive":"2023-09-26T15:17:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":27,"score":null,"hot":3391482987,"url":"https:\/\/community.smartsheet.com\/discussion\/110782\/filter-by-cell-color","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110782\/filter-by-cell-color","format":"Rich","lastPost":{"discussionID":110782,"commentID":396969,"name":"Re: Filter By Cell Color","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396969#Comment_396969","dateInserted":"2023-09-26T15:18:32+00:00","insertUserID":140966,"insertUser":{"userID":140966,"name":"DieHard Jets","url":"https:\/\/community.smartsheet.com\/profile\/DieHard%20Jets","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!nqNr_7IPH7s!7YEoe-ZaUvs!GnmHpUESlnd","dateLastActive":"2023-09-26T15:17:58+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-26T15:18:20+00:00","dateAnswered":"2023-09-26T15:15:31+00:00","acceptedAnswers":[{"commentID":396963,"body":"

We cannot currently filter by cell color. How exactly are you coloring the cells?<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5106,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics

  • Add values after form is created

    After a form is shared with someone else, is it possible that they add a value in another cell?

  • referencing cells

    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…

  • Filter By Cell Color

    Is there a way to create a filter to only show let's say cells highlighted in yellow?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video