Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Offline option

Is there any updates regarding implementing an option to work offline on smartsheet?

«1

Comments

This discussion has been closed.
That helped. Looks like I have a circular reference<\/p>

Field formula is in= 'Summary', So, if none of these conditions are met, copy itself. Not sure if this is possible.<\/p>

=IF([Issue Type]@row= \"Coordinator Request\",[Coordinator Request Types]@row, IF([Issue Type]@row= \"Standard Request\", [Ops Requests]@row, IF([Issue Type]@row= \"Enhancement Request\", [Ops Requests]@row, IF([Issue Type]@row= \"Change Request\", [Ops Requests]@row, Summary@row ))))<\/p>"},{"commentID":395596,"body":"

No. That isn't possible. You will need to put the formula into another column that isn't being reference by the formula itself.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":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-15T19:35:35+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-15T20:51:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":30,"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-15T20:51:11+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":[]},{"discussionID":110334,"type":"question","name":"Question on Function Syntax using IF, AND, and OR","excerpt":"I am trying to get an At Risk check box to return a red flag if there is a date in End Date and that date is earlier than the curent date and the Status cell shows one of three statuses. Can't quite get the formula logic. Any suggestions would be wonderful. Thanks! Desired results: End Date is blank = no flag End Date is…","snippet":"I am trying to get an At Risk check box to return a red flag if there is a date in End Date and that date is earlier than the curent date and the Status cell shows one of three…","categoryID":322,"dateInserted":"2023-09-15T15:25:42+00:00","dateUpdated":"2023-09-15T16:08:50+00:00","dateLastComment":"2023-09-15T17:42:25+00:00","insertUserID":151465,"insertUser":{"userID":151465,"name":"MLK","url":"https:\/\/community.smartsheet.com\/profile\/MLK","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zbHV85tf1Hw!XJ1Un0NmDCQ!G7y689MNH3u","dateLastActive":"2023-09-15T18:00:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-17T19:25:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":35,"score":null,"hot":3389593687,"url":"https:\/\/community.smartsheet.com\/discussion\/110334\/question-on-function-syntax-using-if-and-and-or","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110334\/question-on-function-syntax-using-if-and-and-or","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":110334,"commentID":395594,"name":"Re: Question on Function Syntax using IF, AND, and OR","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/395594#Comment_395594","dateInserted":"2023-09-15T17:42:25+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-09-17T19:25:52+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-15T17:02:14+00:00","dateAnswered":"2023-09-15T16:13:23+00:00","acceptedAnswers":[{"commentID":395571,"body":"

Try this:<\/p>

=IF(AND([End Date]@row <> \"//www.santa-greenland.com/community/discussion/comment/\", [End Date]@row < TODAY(), Status@row <> \"Complete\", Status@row <> \"Executed\", Status@row <> \"Recorded\"), 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","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":254,"urlcode":"formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&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":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts