Formulas and Functions

7 days (green)? Complete would need to turn green regardless of the date while not started and in progress would look at the date parameters. Thanks…","categoryID":322,"dateInserted":"2018-03-05T21:15:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-07T10:58:00+00:00","insertUserID":40251,"insertUser":{"userID":40251,"name":"apmarcotte","url":"https:\/\/community.smartsheet.com\/profile\/apmarcotte","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-03T09:58:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":40251,"lastUser":{"userID":40251,"name":"apmarcotte","url":"https:\/\/community.smartsheet.com\/profile\/apmarcotte","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-03T09:58:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":774,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/20771\/automate-ryg-balls-based-on-status-and-then-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20771\/automate-ryg-balls-based-on-status-and-then-date","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":210,"urlcode":"human-resources","name":"Human Resources"},{"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":20806,"type":"discussion","name":"Automatically Generate Decision Log from Action Item List","excerpt":"I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is selected from the next steps column in the action item log I would like for a line item…","categoryID":322,"dateInserted":"2018-03-06T12:14:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-06T12:19:53+00:00","insertUserID":40331,"insertUser":{"userID":40331,"name":"jcone40331","url":"https:\/\/community.smartsheet.com\/profile\/jcone40331","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/c5\/3a\/nc53a6cd964ace4bd9de3a123bc9c8ccb.JPG","dateLastActive":"2018-05-08T13:31:07+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-10-02T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":1234,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/20806\/automatically-generate-decision-log-from-action-item-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20806\/automatically-generate-decision-log-from-action-item-list","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":215,"urlcode":"templates","name":"Templates"},{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"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":20621,"type":"discussion","name":"Formula Counting Courses Required \/Taken","excerpt":"All, Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a formula that will show me when they have completed all courses that they are required. The…","categoryID":322,"dateInserted":"2018-03-02T18:56:48+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T21:59:39+00:00","insertUserID":6418,"insertUser":{"userID":6418,"name":"Art Miller","url":"https:\/\/community.smartsheet.com\/profile\/Art%20Miller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/06\/a3\/n06a3a1eb049171bb41f139d91deb5a20.png","dateLastActive":"2022-11-14T17:44:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":23666,"lastUser":{"userID":23666,"name":"Chris McKay","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20McKay","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/d5\/d2\/nd5d2693be28ccbd24f978b00c5d1db1d.JPG","dateLastActive":"2018-08-14T22:59:56+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":183,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/20621\/formula-counting-courses-required-taken","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20621\/formula-counting-courses-required-taken","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":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":20706,"type":"discussion","name":"COUNTIFS Question","excerpt":"I'm having an issue understanding COUNTIFS in my scenario. I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can track how many hours go to which projects. I believe COUNTIFS is the right formula to use, but not sure how to apply it. Any…","categoryID":322,"dateInserted":"2018-03-05T10:35:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T17:58:10+00:00","insertUserID":15811,"insertUser":{"userID":15811,"name":"Amy_API","url":"https:\/\/community.smartsheet.com\/profile\/Amy_API","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-10T16:15:27+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-10-02T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":309,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/20706\/countifs-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20706\/countifs-question","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/5b\/e6\/5be658c0a6373413c76601ccd1015b89.PNG"},"alt":"Billable Hours.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":249,"urlcode":"education","name":"Education"},{"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":20736,"type":"discussion","name":"RYG Automation based on \"overall Score\" Column","excerpt":"We do a customer follow up for every job we do. We ask 3 questions rated 1-10. If \"Overall Score\" column totals 26-30 points - green ball 20-25 points - yellow ball >20 points red ball. I can get the column to automatically put the word of the colour in, but not the actual ball. Is there a formula for such a thing? Thanks…","categoryID":322,"dateInserted":"2018-03-05T15:38:49+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T16:18:12+00:00","insertUserID":40221,"insertUser":{"userID":40221,"name":"Mark Dekorte","url":"https:\/\/community.smartsheet.com\/profile\/Mark%20Dekorte","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-05T15:30:57+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-10-02T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":235,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/20736\/ryg-automation-based-on-overall-score-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20736\/ryg-automation-based-on-overall-score-column","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-03\/0c\/72\/0c721d5b3107fa82fd5643e16fc7c1fb.PNG"},"alt":"Capture.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":20531,"type":"discussion","name":"Check Box and Conditional Formatting","excerpt":"Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…","categoryID":322,"dateInserted":"2018-03-02T08:40:50+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T13:35:30+00:00","insertUserID":36626,"insertUser":{"userID":36626,"name":"dana y","url":"https:\/\/community.smartsheet.com\/profile\/dana%20y","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-25T11:32:10+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":798,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/20531\/check-box-and-conditional-formatting","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20531\/check-box-and-conditional-formatting","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":204,"urlcode":"forms","name":"Forms"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"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}]},{"discussionID":20566,"type":"discussion","name":"Best way to report a top of funnel of requests metric","excerpt":"Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…","categoryID":322,"dateInserted":"2018-03-02T13:30:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T13:08:40+00:00","insertUserID":19896,"insertUser":{"userID":19896,"name":"jdawana19896","url":"https:\/\/community.smartsheet.com\/profile\/jdawana19896","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-25T19:51:22+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":224,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/20566\/best-way-to-report-a-top-of-funnel-of-requests-metric","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20566\/best-way-to-report-a-top-of-funnel-of-requests-metric","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":210,"urlcode":"human-resources","name":"Human Resources"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":20661,"type":"discussion","name":"Formula does not always recognize \"//www.santa-greenland.com/community/categories/formulas-and-functions/\" for blanks?","excerpt":"I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…","categoryID":322,"dateInserted":"2018-03-04T22:28:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T13:04:15+00:00","insertUserID":36626,"insertUser":{"userID":36626,"name":"dana y","url":"https:\/\/community.smartsheet.com\/profile\/dana%20y","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-25T11:32:10+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-10-02T20:19:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":254,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/20661\/formula-does-not-always-recognize-for-blanks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20661\/formula-does-not-always-recognize-for-blanks","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":277,"urlcode":"integrations","name":"Integrations"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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":20591,"type":"discussion","name":"IF, AND, OR Functions","excerpt":"So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; i add the third in the second example and it blows up. thanks in advance: works:…","categoryID":322,"dateInserted":"2018-03-02T14:38:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2018-03-05T12:46:45+00:00","insertUserID":36626,"insertUser":{"userID":36626,"name":"dana y","url":"https:\/\/community.smartsheet.com\/profile\/dana%20y","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-25T11:32:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":36626,"lastUser":{"userID":36626,"name":"dana y","url":"https:\/\/community.smartsheet.com\/profile\/dana%20y","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-10-25T11:32:10+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":3804,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/20591\/if-and-or-functions","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20591\/if-and-or-functions","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":204,"urlcode":"forms","name":"Forms"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":277,"urlcode":"integrations","name":"Integrations"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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