Formulas

\"32\", \"width1*hight1*5.5\", \"sqf1 < \"32\"\"width1*hight1*8.5\") I know its looks bad :D Thank you","categoryID":319,"dateInserted":"2017-11-11T13:15:15+00:00","dateUpdated":null,"dateLastComment":"2017-11-22T15:09:51+00:00","insertUserID":12488,"insertUser":{"userID":12488,"name":"Haithem","url":"https:\/\/community.smartsheet.com\/profile\/Haithem","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-11T12:33:02+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":4,"countViews":2,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/15746\/if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/15746\/if-statement","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":215,"urlcode":"templates","name":"Templates"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"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":16141,"type":"discussion","name":"We need Two Cells to Trigger a final cell location","excerpt":"We need When Med4 Quiz is checked and Med4 E Learning is checked, then All Complete needs to automatically check. I have tried =IF(AND([Med4 Quiz]3 < 0, [Med4 E Learning]3 < 0), 1, 0) ...but this is not working for me. Any help with this would be greatly appreciated!","categoryID":319,"dateInserted":"2017-11-22T13:46:55+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-22T14:29:34+00:00","insertUserID":10205,"insertUser":{"userID":10205,"name":"MATRIX Architect","url":"https:\/\/community.smartsheet.com\/profile\/MATRIX%20Architect","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/91\/21\/n91213f13e42917fdc3c81bd1ec0ff2c5.jpg","dateLastActive":"2019-07-19T14:04: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-08-23T14:56:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":4,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16141\/we-need-two-cells-to-trigger-a-final-cell-location","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16141\/we-need-two-cells-to-trigger-a-final-cell-location","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2017-11\/31\/61\/3161858bfdae6b3944f0eb43b70566dc.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet Formula Question 11-22-17.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":234,"urlcode":"health-care","name":"Healthcare"},{"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}]},{"discussionID":16051,"type":"discussion","name":"How to highlight a date in a column based off of another date","excerpt":"Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. Is this possible or is is…","categoryID":319,"dateInserted":"2017-11-19T21:33:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-21T17:57:03+00:00","insertUserID":28711,"insertUser":{"userID":28711,"name":"Erica Fresh","url":"https:\/\/community.smartsheet.com\/profile\/Erica%20Fresh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-19T21:29:01+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":true,"sink":false,"countComments":3,"countViews":326,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/16051\/how-to-highlight-a-date-in-a-column-based-off-of-another-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16051\/how-to-highlight-a-date-in-a-column-based-off-of-another-date","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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":15946,"type":"discussion","name":"Visual budget management","excerpt":"Hello, I'm working on a total overview of projects in a sheet, using different columns with start and end dates and with budget reserved en budget spend. The thing is that I would like to compare the budget reserved with the budget spend. So that when the budget spend is higher then the budget reserved it changes color. I…","categoryID":319,"dateInserted":"2017-11-16T05:29:04+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-20T17:50:53+00:00","insertUserID":28516,"insertUser":{"userID":28516,"name":"Mauk Janssen","url":"https:\/\/community.smartsheet.com\/profile\/Mauk%20Janssen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-20T05:16:43+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":19511,"lastUser":{"userID":19511,"name":"Pam Alakai","url":"https:\/\/community.smartsheet.com\/profile\/Pam%20Alakai","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-07\/ea\/5f\/nea5fc0b91c2d1a6100a72aaf495b044d.JPG","dateLastActive":"2018-02-06T17:21:57+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/15946\/visual-budget-management","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/15946\/visual-budget-management","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":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"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":15996,"type":"discussion","name":"Drag fill across colomns","excerpt":"I have a sheet with 180 columns, each with a \"add sum\" *=sum([column name]:[column name]*. I am trying to \"drag fill\" the add sum across all 180 columns - but the formula does not adjust to the [column name]...any other way of doing this than typing the formula for each column? TY","categoryID":319,"dateInserted":"2017-11-17T02:24:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-20T12:04:05+00:00","insertUserID":17621,"insertUser":{"userID":17621,"name":"WernerDoubell","url":"https:\/\/community.smartsheet.com\/profile\/WernerDoubell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-10-12T04:24:04+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":279,"lastUser":{"userID":279,"name":"Kara Lumley","url":"https:\/\/community.smartsheet.com\/profile\/Kara%20Lumley","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/95\/4e\/n954e10e9b436e9acd6f195bdf2312f07.jpg","dateLastActive":"2020-11-10T15:44:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":542,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/15996\/drag-fill-across-colomns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/15996\/drag-fill-across-colomns","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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"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":16026,"type":"discussion","name":"Finding a formula","excerpt":"I have a formula counting the last 8 numbers in a row. I have hovered over the cell and can't find the formula to copy it to another line what am I doing wrong? ","categoryID":319,"dateInserted":"2017-11-17T12:25:00+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-11-17T20:07:46+00:00","insertUserID":28646,"insertUser":{"userID":28646,"name":"Nolan Sims","url":"https:\/\/community.smartsheet.com\/profile\/Nolan%20Sims","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-11-17T12:21:48+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":13466,"lastUser":{"userID":13466,"name":"Schiff A.","url":"https:\/\/community.smartsheet.com\/profile\/Schiff%20A.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-10\/07\/4c\/n074c56450dd8dc62a9e7df129372b6e2.JPG","dateLastActive":"2020-01-03T17:07:38+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":2,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/16026\/finding-a-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/16026\/finding-a-formula","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":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}">