Formulas and Functions

0, FEB1:FEB5,>0, MAR1:MAR5, >0, APR1:APR5, >0 MAY1:MAY5, >0, JUN1:JUN5,…","categoryID":322,"dateInserted":"2020-06-02T21:33:03+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T21:02:52+00:00","insertUserID":122199,"insertUser":{"userID":122199,"name":"Jack Bidlack","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Bidlack","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-04T21:01:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":122199,"lastUser":{"userID":122199,"name":"Jack Bidlack","url":"https:\/\/community.smartsheet.com\/profile\/Jack%20Bidlack","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-06-04T21:01:45+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":167,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68824\/hello-ive-been-trying-to-use-unique-values-in-one-column-to-determine-what-the-yearly-sum-is","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68824\/hello-ive-been-trying-to-use-unique-values-in-one-column-to-determine-what-the-yearly-sum-is","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2UD5IGLGPX51\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-04T21:01:42+00:00","dateAnswered":"2020-06-02T23:56:50+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":68895,"type":"question","name":"How to include Paranthesis in formula.","excerpt":"I am using an IF formula in a Total column Column A A) Option 1 B) Option 2 Total Column = IF ([Column A]@row = \"A) Option 1\" , \"3\", IF([Column A]@row = \"B) Option 2\" , \"5\")) I am getting error, as ) is prematurely closing out the computation. Any help is much appreciated. Thank you, Deepthi","categoryID":322,"dateInserted":"2020-06-04T19:40:37+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T20:07:34+00:00","insertUserID":99556,"insertUser":{"userID":99556,"name":"dsmartsheetuser","url":"https:\/\/community.smartsheet.com\/profile\/dsmartsheetuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:30:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":99556,"lastUser":{"userID":99556,"name":"dsmartsheetuser","url":"https:\/\/community.smartsheet.com\/profile\/dsmartsheetuser","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-21T20:30:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":73,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/68895\/how-to-include-paranthesis-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68895\/how-to-include-paranthesis-in-formula","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":68402,"type":"question","name":"RAG Calculation to highlight Red, Green and Blue balls","excerpt":"I cannot work out how to combine the following arguments into one cell and calculate, i have spend hours trying and getting no where, would appreciate any help. The following will return a red or green to the RAG column and works perfectly : =IF([Baseline Variance]@row <= 0, \"Green\", IF([Baseline Variance]@row >= 1,…","categoryID":322,"dateInserted":"2020-05-18T15:10:42+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T18:07:19+00:00","insertUserID":116748,"insertUser":{"userID":116748,"name":"Dan Harris","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Dan%20Harris","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-02-21T09:55:55+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":5,"countViews":175,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/68402\/rag-calculation-to-highlight-red-green-and-blue-balls","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68402\/rag-calculation-to-highlight-red-green-and-blue-balls","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":68880,"type":"question","name":"Complex COUNTIFS and IF Function","excerpt":"Hello, I need help putting together a function that can count certain cells in my grid. The inputs of the function are the following: If Beta is \"Yes\", it should be counted twice If Beta is \"No\", it should be counted once But if the Primary Region Column is not checked, the row should not be counted at all. Beta is a…","categoryID":322,"dateInserted":"2020-06-04T14:25:23+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T15:39:47+00:00","insertUserID":122165,"insertUser":{"userID":122165,"name":"Mashall Greene","url":"https:\/\/community.smartsheet.com\/profile\/Mashall%20Greene","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HF1a3wHviMQ!zAHZs9mDxvw!ycVqYafDeiB","dateLastActive":"2020-06-26T20:17:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":122,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/68880\/complex-countifs-and-if-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68880\/complex-countifs-and-if-function","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-08T06:28:37+00:00","dateAnswered":"2020-06-04T15:08:39+00:00","acceptedAnswers":[]}},"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":68624,"type":"question","name":"Checking box if form submitter has selected certain options from a multi-select drop down","excerpt":"Hi, I am new to Smartsheet and have a form where there are about one hundred options in a multi-select drop down, they are subjects of expertise the person could speak on. 15 of the options are in the technology category of expertise. I want a checkbox to be automatically checked if the person selects one or more of the 15…","categoryID":322,"dateInserted":"2020-05-26T21:06:13+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T15:39:26+00:00","insertUserID":121950,"insertUser":{"userID":121950,"name":"Justin Guest","url":"https:\/\/community.smartsheet.com\/profile\/Justin%20Guest","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-05-28T20:40:46+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":157,"score":null,"hot":9,"url":"https:\/\/community.smartsheet.com\/discussion\/68624\/checking-box-if-form-submitter-has-selected-certain-options-from-a-multi-select-drop-down","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68624\/checking-box-if-form-submitter-has-selected-certain-options-from-a-multi-select-drop-down","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":68875,"type":"question","name":"Saving column selection in update requests","excerpt":"Hallo, when I want to send an update request I always have to deselect a number of columns before I can send the request. Wouldn´t it be nice to save different settings f.e. department 1, client 2 ? What do you think? 😉","categoryID":322,"dateInserted":"2020-06-04T08:44:57+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T15:09:08+00:00","insertUserID":107466,"insertUser":{"userID":107466,"name":"Joerg Schmidt","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joerg%20Schmidt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZFNXGZNkaTw!pKDXaa84r-Y!9WSWmAUhJKN","dateLastActive":"2023-05-04T06:23:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":81,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68875\/saving-column-selection-in-update-requests","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68875\/saving-column-selection-in-update-requests","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/5E3VD8593V0Z\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-04T15:12:32+00:00","dateAnswered":"2020-06-04T11:44:36+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[],"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":68881,"type":"question","name":"Assign Ownership to A Group","excerpt":"Hello, Can ownership of a sheet be assigned to a Smartsheet group? Our goal is to have the email notifications display the group name as opposed to the individual owners name. Thanks!","categoryID":322,"dateInserted":"2020-06-04T15:01:39+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T15:04:33+00:00","insertUserID":51391,"insertUser":{"userID":51391,"name":"Katye Reed","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Katye%20Reed","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-04\/47\/e4\/n47e417a625675c0c55a8e9a3eb9c663a.jpg","dateLastActive":"2021-10-27T20:01:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":114,"score":1,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/68881\/assign-ownership-to-a-group","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68881\/assign-ownership-to-a-group","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":338,"urlcode":"permission-problem","name":"Permission Problem"},{"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}]},{"discussionID":68802,"type":"question","name":"Need to Count Unique Values Based on Criteria from a DropDown Collumn","excerpt":"Hello, I need a function that can identity duplicates and determine if they should be counted as one or more than one depending on criteria within another column of the spreadsheet that is a dropdown. The specific context is there is a Name Column (Column A) and a Dropdown Column (Column B), Column B has three options \"Yes…","categoryID":322,"dateInserted":"2020-06-02T13:52:05+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T14:32:32+00:00","insertUserID":122165,"insertUser":{"userID":122165,"name":"Mashall Greene","url":"https:\/\/community.smartsheet.com\/profile\/Mashall%20Greene","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!HF1a3wHviMQ!zAHZs9mDxvw!ycVqYafDeiB","dateLastActive":"2020-06-26T20:17:20+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":404,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/68802\/need-to-count-unique-values-based-on-criteria-from-a-dropdown-collumn","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68802\/need-to-count-unique-values-based-on-criteria-from-a-dropdown-collumn","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"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":319,"urlcode":"functionality","name":"functionality"}],"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":68833,"type":"question","name":"Help with RYG IF Statement and consider a Blank Cell","excerpt":"I have a sheet to measure KPI's for a project. Bascially I'm trying to record when we submit a report; If the Submission Date falls before the 4 Week Limit (Purple Helper Column) KPI 2 returns Green If the Submission Date lands after the 4 week limit but less than 14 days 'late' KPI 2 returns Yellow If the Submissinon Date…","categoryID":322,"dateInserted":"2020-06-03T07:09:29+00:00","dateUpdated":null,"dateLastComment":"2020-06-04T12:21:55+00:00","insertUserID":87801,"insertUser":{"userID":87801,"name":"Richard Heath","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Richard%20Heath","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/PQ5MK3GA3T0T\/nRH0VLM6IQ91L.jpg","dateLastActive":"2023-08-25T00:43:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"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-08-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":283,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/68833\/help-with-ryg-if-statement-and-consider-a-blank-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68833\/help-with-ryg-if-statement-and-consider-a-blank-cell","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/O8H84QVDB0CA\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-06-03T22:06:49+00:00","dateAnswered":"2020-06-03T12:12:59+00:00","acceptedAnswers":[]}},"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Help Article Resources