Formulas

=TODAY(+180)) Failed Attempt 2: =COUNTIF([Renewal Date]2, >=TODAY()180) Failed Attempt 3: =COUNTIF([Renewal…","categoryID":322,"dateInserted":"2018-05-15T16:21:08+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-15T19:02:23+00:00","insertUserID":3680,"insertUser":{"userID":3680,"name":"Darcie Wilson","url":"https:\/\/community.smartsheet.com\/profile\/Darcie%20Wilson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-15T16:09:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":936,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/25316\/countif-date-is-in-the-next-180-days-from-today","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25316\/countif-date-is-in-the-next-180-days-from-today","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":4051,"type":"discussion","name":"Calculate days remaining","excerpt":"I have an estimated project Finish date of 8\/9\/16 in a column \"Finish\". this date is in row 6 and row 161. I have entered a row name TODAY and set the date to current date in the 'Finish\" column row 4. I attempted to use the formula: =NETDAYS([Finish]6,[Finish]4) I get no result or error message. Just the formula. What am…","categoryID":318,"dateInserted":"2016-01-28T09:57:14+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-15T12:01:52+00:00","insertUserID":5258,"insertUser":{"userID":5258,"name":"Michael Lang","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Lang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-28T09:42:23+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":5651,"lastUser":{"userID":5651,"name":"Stan Adell","url":"https:\/\/community.smartsheet.com\/profile\/Stan%20Adell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/85\/ad\/n85ad0d191e91807aa433dec2c6e10aa3.jpg","dateLastActive":"2020-11-13T19:09:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":198,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/4051\/calculate-days-remaining","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/4051\/calculate-days-remaining","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/02\/fd\/02fdb99764d0bfa08df74d91803a9b29.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Date calculation issue.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":263,"urlcode":"government","name":"Government"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}],"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}]},{"discussionID":25091,"type":"discussion","name":"Dashboard - Charting how many checked out of total boxes","excerpt":"I have a sheet that has checkboxes. I would like to be able to make a chart in the dashboard that shows percentage of how many checked out of total. I have a count for the checked boxes, but no total to reference. How would I go about this?","categoryID":322,"dateInserted":"2018-05-10T19:21:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-14T16:09:34+00:00","insertUserID":47741,"insertUser":{"userID":47741,"name":"Winkle_ProjectCoordinator","url":"https:\/\/community.smartsheet.com\/profile\/Winkle_ProjectCoordinator","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-26T15:36:11+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11072,"lastUser":{"userID":11072,"name":"Mike Wilday","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Wilday","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/749H48MC3045\/nF9FQYPTX0X7D.jpg","dateLastActive":"2023-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":648,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/25091\/dashboard-charting-how-many-checked-out-of-total-boxes","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25091\/dashboard-charting-how-many-checked-out-of-total-boxes","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":25196,"type":"discussion","name":"%Complete to be automated","excerpt":"I am trying to work on my sheet to get the % Completed to be automated. How can I go about doing this?","categoryID":322,"dateInserted":"2018-05-14T09:43:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-14T15:32:03+00:00","insertUserID":46491,"insertUser":{"userID":46491,"name":"justin46491","url":"https:\/\/community.smartsheet.com\/profile\/justin46491","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-08-27T09:55:59+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":43671,"lastUser":{"userID":43671,"name":"RebSchr","title":"","url":"https:\/\/community.smartsheet.com\/profile\/RebSchr","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/3ADULST8KTC5\/nEXJM7VU8H7HW.jpg","dateLastActive":"2023-08-24T20:47:23+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":339,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/25196\/complete-to-be-automated","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25196\/complete-to-be-automated","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":25201,"type":"discussion","name":"SUMIF","excerpt":"Hi all, I am trying to add a range of cells on condition that it does not contain any value that is equal to\/or less than 0. for instance (12,45,24,0,65) should equal 0 and (12,24,24,10,65) give me 135. anyone to help?","categoryID":322,"dateInserted":"2018-05-14T11:03:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-14T12:36:16+00:00","insertUserID":47911,"insertUser":{"userID":47911,"name":"Musa","url":"https:\/\/community.smartsheet.com\/profile\/Musa","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-14T10:59:52+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":11270,"lastUser":{"userID":11270,"name":"Matt Hagler","url":"https:\/\/community.smartsheet.com\/profile\/Matt%20Hagler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/94\/e2\/n94e2afbdd827241f05f4197b47d5c461.jpg","dateLastActive":"2018-05-14T12:16:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":53,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25201\/sumif","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25201\/sumif","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}],"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}]},{"discussionID":12141,"type":"discussion","name":"Calculating Variances with Negative Numbers","excerpt":"How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)\/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…","categoryID":319,"dateInserted":"2017-08-03T18:19:46+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-14T12:31:52+00:00","insertUserID":20211,"insertUser":{"userID":20211,"name":"elliot_gold","url":"https:\/\/community.smartsheet.com\/profile\/elliot_gold","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-12-19T13:05:29+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":9,"countViews":4689,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/12141\/calculating-variances-with-negative-numbers","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/12141\/calculating-variances-with-negative-numbers","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":25071,"type":"discussion","name":"Allocation in Template Sets","excerpt":"Good morning. I joined the webinar yesterday regarding Template Sets and we've already begun creating a sheet for our projects using one of these template sets. Great job Smartsheet!!! We love the compatibility you have created with Project and this will definitely benefit us in the very near future. I did notice, however,…","categoryID":322,"dateInserted":"2018-05-10T13:52:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-14T12:21:39+00:00","insertUserID":7105,"insertUser":{"userID":7105,"name":"Laurie Bearden","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Laurie%20Bearden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/001\/nT12MT79U1BCE.jpg","dateLastActive":"2023-05-04T17:46:15+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25071\/allocation-in-template-sets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25071\/allocation-in-template-sets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User Management"}],"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}]},{"discussionID":25131,"type":"discussion","name":"Is there a way to tell if a cell is used in another formula or not?","excerpt":"I have a sheet that I inherited and it has all kinds of fields used for statistic reporting. I want to edit the sheet, but don't know what formulas on this or other sheets I might break if I edit it. Is there a way to know if a cell is used in a formula somewhere else? Thanks, Carolyn","categoryID":322,"dateInserted":"2018-05-11T11:08:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-11T16:06:15+00:00","insertUserID":5424,"insertUser":{"userID":5424,"name":"Carolyn Stone","url":"https:\/\/community.smartsheet.com\/profile\/Carolyn%20Stone","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:22:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":16866,"lastUser":{"userID":16866,"name":"L_123","title":"","url":"https:\/\/community.smartsheet.com\/profile\/L_123","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-22T21:15:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":95,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/25131\/is-there-a-way-to-tell-if-a-cell-is-used-in-another-formula-or-not","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25131\/is-there-a-way-to-tell-if-a-cell-is-used-in-another-formula-or-not","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}]},{"discussionID":25056,"type":"discussion","name":"IF Statements and Linking Sheets by Ranges","excerpt":"Hi, I am working on a project creating a weekly sheet for distribution where one week of info is pulled from a range of data on a separate 13-week sheet. Basically, on the weekly sheet, I am using IF() statements to search a cell on the 13-week sheet for text. If the cell contains the proper text, the name from that row on…","categoryID":322,"dateInserted":"2018-05-10T12:16:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-11T12:35:26+00:00","insertUserID":47681,"insertUser":{"userID":47681,"name":"hthoms","url":"https:\/\/community.smartsheet.com\/profile\/hthoms","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-12T14:10:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":72,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25056\/if-statements-and-linking-sheets-by-ranges","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25056\/if-statements-and-linking-sheets-by-ranges","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/59\/e9\/59e9f60c9ccf9396503d9eac1adcba25.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"13-week Schedule.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}]},{"discussionID":25051,"type":"discussion","name":"Use a form to lookup sheet data that and add content to it","excerpt":"Hello, I have read the forms with the “VLOOKUP” and “LOOKUP” functions. I am new to smart sheet, but not to excel formulas. I have an associate inspecting carts for wear and tear items, this is working well with check boxes and the photo attachment is awesome to have. Next step is the associate that repairs the cart, I…","categoryID":322,"dateInserted":"2018-05-10T11:23:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-11T12:06:43+00:00","insertUserID":47671,"insertUser":{"userID":47671,"name":"JTrumble","url":"https:\/\/community.smartsheet.com\/profile\/JTrumble","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-10T11:14:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":195,"lastUser":{"userID":195,"name":"Shaine Greenwood","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Shaine%20Greenwood","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/198\/nBSBY6VR571R7.jpg","dateLastActive":"2021-08-30T16:03:52+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1034,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25051\/use-a-form-to-lookup-sheet-data-that-and-add-content-to-it","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25051\/use-a-form-to-lookup-sheet-data-that-and-add-content-to-it","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":214,"urlcode":"search","name":"Search"},{"tagID":245,"urlcode":"sharing","name":"Sharing and Collaboration"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"},{"tagID":510,"urlcode":"email-notifications","name":"Email Notifications"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">