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
Comments
-
Travis Employee
Hi Suzaan, we dont have any near term plans to add the ability to work on Smartsheet offline but we are tracking feedback for this request and I'll add you vote for it!
-
Travis Employee
Thanks for the post, George! I will submit your vote for this request.
An approach some users will take is to export the sheet to Excel if they need to work on it offline, then copy and paste the changes from Excel to Smartsheet.
-
Preston ✭✭✭✭✭
对不起。不确定哪个帖子被跟踪的fline support, but I'm casting a vote here!
Thank you!
-
Amye ✭
Hi Travis,
+1 for me also.
I'd love to have even webforms available offline and sync when the person imputting the data is back online.
Ie if travelling and away from internet or remote access, input via webform then have the data captured for when you are back in range?
-
Travis Employee
Thanks everyone, your votes have been added!
-
Hi, checking in on offline option as well. It may also be useful for recurring themes to be consolidated in one conversation or, at a minimum, sort the forum by date. I 'm not certain if there are more recent posts about working offline.
-
Lena1 ✭
I agree. It would be a huge benefit to have offline capability given that internet access is not always a guarantee. I would like to make smartsheet more central to all of my business processes, but not having the offline option has kept me from fully implementing the smartsheet.
-
Kennedy Stomps Employee
Hi Wayne and Lena-- I have added your votes!
-
masn ✭
Travis -
Thanks for keeping the dialogue alive.
How about letting us know why it is not a near-term plan - not on strategy, not possible? There's a lot riding on decisions to use or not use a tool.
-
Please tell me that Smartsheet is concidering this. I still think that there are way more users that will benefit.
-
汤姆Jodeit ✭
Another vote here for offline access!
-
ehager ✭
Considering moving to SS from Project. But must be able to work off-line. Business takes me to many places without internet.
Vote for off-line access
Categories
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":"