Formulas

50 AND <100, \"Yellow\")","categoryID":322,"dateInserted":"2018-05-23T14:56:37+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T17:51:18+00:00","insertUserID":48146,"insertUser":{"userID":48146,"name":"Beth Blome","url":"https:\/\/community.smartsheet.com\/profile\/Beth%20Blome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-29T10:15:53+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-03T21:02:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":81,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/25836\/trouble-with-ryg-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25836\/trouble-with-ryg-formula","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":25781,"type":"discussion","name":"Inserting a Formula into an existing Equation","excerpt":"I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 \/ 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number \"60\" with…","categoryID":322,"dateInserted":"2018-05-22T16:23:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T17:35:44+00:00","insertUserID":48846,"insertUser":{"userID":48846,"name":"n.burch","url":"https:\/\/community.smartsheet.com\/profile\/n.burch","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!XNPCXzqeB_4!pF9B6ULJqPo!rEAD2ZjfcnL","dateLastActive":"2022-07-18T21:43:28+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-03T21:02:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":64,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/25781\/inserting-a-formula-into-an-existing-equation","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25781\/inserting-a-formula-into-an-existing-equation","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/af\/77\/af7703584f29c61cb8c8669185f08efe.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"snip.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"Finance","name":"Finance"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":266,"urlcode":"Real Estate","name":"Real Estate"},{"tagID":281,"urlcode":"Support","name":"Support"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":25681,"type":"discussion","name":"gantt chart - dependencies that are not necessarily SS or FF (or any other combination)","excerpt":"I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…","categoryID":322,"dateInserted":"2018-05-22T01:49:20+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-23T15:24:57+00:00","insertUserID":48731,"insertUser":{"userID":48731,"name":"bbelman","url":"https:\/\/community.smartsheet.com\/profile\/bbelman","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-07-28T02:24:33+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":143,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25681\/gantt-chart-dependencies-that-are-not-necessarily-ss-or-ff-or-any-other-combination","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25681\/gantt-chart-dependencies-that-are-not-necessarily-ss-or-ff-or-any-other-combination","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":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":25481,"type":"discussion","name":"COUNTIFS on Status and Date Range","excerpt":"Hi Guys I am trying to calculate instances whereby: Status Column = \"Scheduled\" AND Date Column = date range One of my attempts is shown in the screenshot below, I have tried a few tweeks but can't seem to quite get it right. Any help \/ advice \/ guidance would be most appreciated! ","categoryID":322,"dateInserted":"2018-05-18T05:14:59+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-22T16:54:10+00:00","insertUserID":48376,"insertUser":{"userID":48376,"name":"Sel","url":"https:\/\/community.smartsheet.com\/profile\/Sel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-18T05:11:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":14396,"lastUser":{"userID":14396,"name":"Robert S.","url":"https:\/\/community.smartsheet.com\/profile\/Robert%20S.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-06\/15\/71\/n1571b9c12b9098ef693fffa5813f0c39.jpg","dateLastActive":"2020-02-28T21:06:14+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":121,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25481\/countifs-on-status-and-date-range","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25481\/countifs-on-status-and-date-range","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/5e\/3e\/5e3e25145ec6d4f1abd85ed7b0da8da3.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Snip.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":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":25376,"type":"discussion","name":"SOLVED - COUNTIFS Problem","excerpt":"Hi, I'm trying to return a status within a range when the finish date is within 7 days, I've tried a few alternatives with the latest below (using @cell) which I know isn't correct but I'm hoping I'm close. Any advice would be greatly appreciated. =COUNTIFS({RangeStatus}, [Not Started]1, {RangeFinish}, @cell <=TODAY(),…","categoryID":322,"dateInserted":"2018-05-16T17:35:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-22T03:17:26+00:00","insertUserID":48221,"insertUser":{"userID":48221,"name":"Outofmydepth","url":"https:\/\/community.smartsheet.com\/profile\/Outofmydepth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T03:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":48221,"lastUser":{"userID":48221,"name":"Outofmydepth","url":"https:\/\/community.smartsheet.com\/profile\/Outofmydepth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-22T03:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":642,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/25376\/solved-countifs-problem","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25376\/solved-countifs-problem","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":25661,"type":"discussion","name":"Counting Past Due Task","excerpt":"Is there a way to count past due tasks in Smartsheet? I would prefer to count based off of the finish date, but cannot seem to get the formula to work. I am fairly new with the software, so any recommendations would be great! Please let me know. -Branden ","categoryID":322,"dateInserted":"2018-05-21T16:05:18+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-21T21:49:12+00:00","insertUserID":48661,"insertUser":{"userID":48661,"name":"bmcmichael48661","url":"https:\/\/community.smartsheet.com\/profile\/bmcmichael48661","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-07-17T09:18:35+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":48356,"lastUser":{"userID":48356,"name":"PeterG","url":"https:\/\/community.smartsheet.com\/profile\/PeterG","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-05-03T02:51:08+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":61,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25661\/counting-past-due-task","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25661\/counting-past-due-task","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":25511,"type":"discussion","name":"VLOOKUP Annoyance","excerpt":"Does anybody know if there is a way to rid of this annoying fly-out when viewing a sheet that has some references in it?","categoryID":322,"dateInserted":"2018-05-18T10:53:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-21T19:57:11+00:00","insertUserID":48421,"insertUser":{"userID":48421,"name":"Andrew Vanden Heuvel","url":"https:\/\/community.smartsheet.com\/profile\/Andrew%20Vanden%20Heuvel","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-03-05T23:07:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":52,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/25511\/vlookup-annoyance","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25511\/vlookup-annoyance","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-05\/e2\/99\/e299c6b166aa37fa3467ef6f62af165a.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"vlookup.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":211,"urlcode":"Manufacturing","name":"Manufacturing"},{"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":25641,"type":"discussion","name":"If and Vlookup","excerpt":"I'm new to Smartsheets and I'm trying to figure out how to do an IF([Response]3=\"Yes\", VLookup formula linked to a reference data sheet. I've tried various ways to input and always get Unparseable. Any help is appreciated!","categoryID":322,"dateInserted":"2018-05-21T12:45:09+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-21T15:37:49+00:00","insertUserID":48616,"insertUser":{"userID":48616,"name":"DDorough","url":"https:\/\/community.smartsheet.com\/profile\/DDorough","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-21T12:41:22+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-03T21:02:22+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":2224,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/25641\/if-and-vlookup","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25641\/if-and-vlookup","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":5414,"type":"discussion","name":"Formula to reference cell in another sheet?","excerpt":"Hi, I'm wondering if it's possible to reference a cell in a different sheet with a formula. My source sheet is intended for users to add entries, and my destination sheet is intended to keep track of when the source sheet was last updated. Because entries are added to the source sheet, and I always want the newest date on…","categoryID":318,"dateInserted":"2016-07-05T10:38:35+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-21T12:47:43+00:00","insertUserID":7256,"insertUser":{"userID":7256,"name":"Walter Day","url":"https:\/\/community.smartsheet.com\/profile\/Walter%20Day","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-06-30T15:55:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":6388,"lastUser":{"userID":6388,"name":"Gwyneth C","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Gwyneth%20C","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/76\/d9\/n76d9186b3bda2b96a96e61f72e8c9a49.jpg","dateLastActive":"2022-05-19T16:40:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":4458,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/5414\/formula-to-reference-cell-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/5414\/formula-to-reference-cell-in-another-sheet","format":"Html","groupID":null,"statusID":0,"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"}],"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":25506,"type":"discussion","name":"Referencing % in Formula in Symbol Column (RYG)","excerpt":"Is there a trick to referencing % Percentages)when using the If function, automating the RYG symbols in a Symbol column? I have a simple IF formula referencing cell formatted to %. When I replace the % with any text and update formula to reflect the change, the correct RYG symbol is displayed. When I attempt to reference…","categoryID":322,"dateInserted":"2018-05-18T10:49:32+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-05-20T20:49:01+00:00","insertUserID":37926,"insertUser":{"userID":37926,"name":"lisa. caldwell37926","url":"https:\/\/community.smartsheet.com\/profile\/lisa.%20caldwell37926","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-02\/39\/76\/n3976e8f53ea1f263cca7f4d281f19e18.jpg","dateLastActive":"2018-05-30T23:17:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":16211,"lastUser":{"userID":16211,"name":"MichelleMWatkins","url":"https:\/\/community.smartsheet.com\/profile\/MichelleMWatkins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-20T20:08:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":395,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/25506\/referencing-in-formula-in-symbol-column-ryg","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/25506\/referencing-in-formula-in-symbol-column-ryg","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":281,"urlcode":"Support","name":"Support"}],"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}">