@Jillian M<\/a> an IF statement will do what you need.<\/p>=if([Column Name]@row=\"Value\",1,0)<\/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":107679,"type":"question","name":"Update\/Change a Template","excerpt":"Is there a way to edit\/update a template without using the template to create a sheet, editing the sheet, and saving as a new template? This process creates additional templates that might have to be renamed and then removed. I'm looking for something that makes the process a little easier. Thanks! Regina","snippet":"Is there a way to edit\/update a template without using the template to create a sheet, editing the sheet, and saving as a new template? This process creates additional templates…","categoryID":321,"dateInserted":"2023-07-17T16:46:21+00:00","dateUpdated":null,"dateLastComment":"2023-07-24T15:08:21+00:00","insertUserID":149002,"insertUser":{"userID":149002,"name":"rshelnutt","url":"https:\/\/community.smartsheet.com\/profile\/rshelnutt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3IPrv6vEirM!3gtxf4N8l_I!n1V7tv0XPpy","dateLastActive":"2023-07-24T15:35:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":149002,"lastUser":{"userID":149002,"name":"rshelnutt","url":"https:\/\/community.smartsheet.com\/profile\/rshelnutt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3IPrv6vEirM!3gtxf4N8l_I!n1V7tv0XPpy","dateLastActive":"2023-07-24T15:35:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3379824882,"url":"https:\/\/community.smartsheet.com\/discussion\/107679\/update-change-a-template","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107679\/update-change-a-template","format":"Rich","lastPost":{"discussionID":107679,"commentID":386660,"name":"Re: Update\/Change a Template","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386660#Comment_386660","dateInserted":"2023-07-24T15:08:21+00:00","insertUserID":149002,"insertUser":{"userID":149002,"name":"rshelnutt","url":"https:\/\/community.smartsheet.com\/profile\/rshelnutt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!3IPrv6vEirM!3gtxf4N8l_I!n1V7tv0XPpy","dateLastActive":"2023-07-24T15:35:45+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-07-24T15:01:44+00:00","dateAnswered":"2023-07-17T19:14:49+00:00","acceptedAnswers":[{"commentID":385618,"body":"
Unfortunately not, but I do see how it could be handy to be able to just adjust the template itself. Feel free to browse the Product Ideas tab at the top of this page. If someone else has already submitted the idea, you can add your vote. If no one has already, you can submit it yourself and give others the ability to add their votes.<\/p>
Either way, please post a link to the idea to this thread so that others searching for the same thing can easily locate the idea and add their vote.<\/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":107883,"type":"question","name":"Moving closed \"tickets\" to a second sheet","excerpt":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is \"completed\" and over 3 days old to the second sheet. This works well.…","snippet":"I have a sheet where we log our support as it comes in. I have a \"completed\" check box to check once it is finished. It also has a date created field. I setup a second copy of the…","categoryID":321,"dateInserted":"2023-07-20T20:03:02+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":163730,"lastUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":51,"score":null,"hot":3379770739,"url":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107883\/moving-closed-tickets-to-a-second-sheet","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":107883,"commentID":386291,"name":"Re: Moving closed \"tickets\" to a second sheet","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386291#Comment_386291","dateInserted":"2023-07-20T20:49:17+00:00","insertUserID":163730,"insertUser":{"userID":163730,"name":"TheoR74","title":"Manager","url":"https:\/\/community.smartsheet.com\/profile\/TheoR74","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-21T18:44:41+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-07-20T20:50:00+00:00","dateAnswered":"2023-07-20T20:14:12+00:00","acceptedAnswers":[{"commentID":386274,"body":"
@TheoR74<\/a>,<\/p>As long as your destination sheet doesn't have the numbering column setup as an Auto Number, you should be fine. In your destination sheet, keep the numbering column as a \"Text\/Number\" column instead.<\/p>
BRgds,<\/p>
-Ray<\/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":334,"urlcode":"automations","name":"Automations"}]}],"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":4871,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
Trending in Smartsheet Basics
True/False formula? I'm trying to figure out a formula to note a "1" in the cell if the information in the cell next to it is a certain value, any other value needs to show a "0". Is this a "true/false" formula? I figured this out: =IF([Question 1]@row = "2. I should avoid using the electronic device during the initial connection; however,…
Update/Change a Template Is there a way to edit/update a template without using the template to create a sheet, editing the sheet, and saving as a new template? This process creates additional templates that might have to be renamed and then removed. I'm looking for something that makes the process a little easier. Thanks! Regina
Moving closed "tickets" to a second sheet I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…
Andrée Starå ✭✭✭✭✭✭
