👍️<\/span><\/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":110373,"type":"question","name":"10 digit fixed numeric field","excerpt":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric\/text etc...they don't help what I need. Also, Can we trigger any flash alert for…","snippet":"Hi, I have few fields where I want to add a validation\/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do…","categoryID":321,"dateInserted":"2023-09-17T21:57:39+00:00","dateUpdated":null,"dateLastComment":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":165902,"lastUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":23,"score":null,"hot":3390024673,"url":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110373\/10-digit-fixed-numeric-field","format":"Rich","tagIDs":[204,254],"lastPost":{"discussionID":110373,"commentID":395685,"name":"Re: 10 digit fixed numeric field","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395685#Comment_395685","dateInserted":"2023-09-18T11:13:34+00:00","insertUserID":165902,"insertUser":{"userID":165902,"name":"Arts B.","url":"https:\/\/community.smartsheet.com\/profile\/Arts%20B.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-19T14:35:05+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-18T11:33:19+00:00","dateAnswered":"2023-09-18T11:13:34+00:00","acceptedAnswers":[{"commentID":395685,"body":"Thanks, Tim, for replying. Yes, I read more on the community about and found the same workaround....I already applied it.<\/p>
(my users are floor workers and works in the shift-only issue here is they don't check emails that often.) so this workaround has limitation in this case. But I'll mark this close as, no actual solution available in Smartsheet.<\/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":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":110349,"type":"question","name":"Need to check and uncheck a box based on a percentage being above 0 and less than 100.","excerpt":"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,…","snippet":"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…","categoryID":321,"dateInserted":"2023-09-15T18:43:40+00:00","dateUpdated":null,"dateLastComment":"2023-09-15T19:35:13+00:00","insertUserID":154002,"insertUser":{"userID":154002,"name":"SmartSheet Newbie","url":"https:\/\/community.smartsheet.com\/profile\/SmartSheet%20Newbie","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OLZT5TMCDLUA\/nLGJGXEA8PX07.png","dateLastActive":"2023-09-19T14:33:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":52616,"lastUser":{"userID":52616,"name":"Nic Larsen","url":"https:\/\/community.smartsheet.com\/profile\/Nic%20Larsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-09-19T15:04:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":38,"score":null,"hot":3389611733,"url":"https:\/\/community.smartsheet.com\/discussion\/110349\/need-to-check-and-uncheck-a-box-based-on-a-percentage-being-above-0-and-less-than-100","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110349\/need-to-check-and-uncheck-a-box-based-on-a-percentage-being-above-0-and-less-than-100","format":"Rich","lastPost":{"discussionID":110349,"commentID":395617,"name":"Re: Need to check and uncheck a box based on a percentage being above 0 and less than 100.","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395617#Comment_395617","dateInserted":"2023-09-15T19:35:13+00:00","insertUserID":52616,"insertUser":{"userID":52616,"name":"Nic Larsen","url":"https:\/\/community.smartsheet.com\/profile\/Nic%20Larsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-09-19T15:04:12+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-15T19:29:36+00:00","dateAnswered":"2023-09-15T19:18:57+00:00","acceptedAnswers":[{"commentID":395613,"body":"
Try: =IF([Percent Completed]@row = 1, 0, IF([Percent Completed]@row > 0, 1))<\/p>"},{"commentID":395617,"body":"
@SmartSheet Newbie<\/a> <\/p>If the % complete = 100% (which is a 1 in a formula), then uncheck which is a 0 value in a checkbox column. <\/p>
If the % complete is greater than 0, check the box (which is a 1 value). <\/p>
If % complete is zero, it will also be unchecked.<\/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":5090,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Smartsheet Basics
Is it advisable to migrate from- Smartsheet to Jira? My team has been planning to migrate all our projects from Smartsheet to Jira and we would like to hear from a professional if it is advisable to do so.
10 digit fixed numeric field Hi, I have few fields where I want to add a validation/control user to force doing the correct entry - e.g. PO# shouldn't be more or less than 10 digits. Is it possible? They do these entries via Form. I see their are new validations numeric/text etc...they don't help what I need. Also, Can we trigger any flash alert for…
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,…