Formulas

500, or losses > than 0, then the \"TOTAL\" cell shows a dollar sign…","categoryID":317,"dateInserted":"2015-04-26T13:54:43+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-27T14:33:23+00:00","insertUserID":1183,"insertUser":{"userID":1183,"name":"Daniel Thornton","url":"https:\/\/community.smartsheet.com\/profile\/Daniel%20Thornton","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-07-22T10:13:25+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":282,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/181\/money-format-in-cell-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/181\/money-format-in-cell-not-working","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"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}]},{"discussionID":156,"type":"discussion","name":"Active Reports","excerpt":"Has anyone out there been able to achieve this? What I would call an Active Report is as follows. A visually formatted report page that is interactive with a master sheet. The report sheet would be formatted to display a ascetically pleasing presentation of data select from the master sheet by selecting a row. This could…","categoryID":317,"dateInserted":"2015-04-23T04:21:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-23T12:03:03+00:00","insertUserID":1132,"insertUser":{"userID":1132,"name":"Gary Webster","url":"https:\/\/community.smartsheet.com\/profile\/Gary%20Webster","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-23T04:07:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":62,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/156\/active-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/156\/active-reports","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":227,"urlcode":"api-and-developers","name":"API and Developers"},{"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":123,"type":"discussion","name":"Update Requests Limited?","excerpt":"I am sending update requests for a sheet that has initial items filled in by formulas - dates, as well as \"Yes\/No\" dropdown selections. This makes it easy for the person who starts with this template to put in suggested initial dates, then ask for exact dates from these directly involved. In the sheet the editor can…","categoryID":317,"dateInserted":"2015-04-17T13:49:06+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-20T09:51:19+00:00","insertUserID":859,"insertUser":{"userID":859,"name":"Brian Dowler","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Dowler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-20T09:48:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":859,"lastUser":{"userID":859,"name":"Brian Dowler","url":"https:\/\/community.smartsheet.com\/profile\/Brian%20Dowler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-04-20T09:48:31+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":33,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/123\/update-requests-limited","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/123\/update-requests-limited","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":86,"type":"discussion","name":"How can I conditionally update a cell but leave the current value there if the condition fails?","excerpt":"I keep track of about 40 active projects in our company. Among other things, I keep one Smartsheet on each project that shows the hours worked by several different functional areas on a week-by-week basis. I only want to put the current week's hours into the project history row for the current week after they have been…","categoryID":317,"dateInserted":"2015-04-07T14:12:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-08T17:50:51+00:00","insertUserID":459,"insertUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":459,"lastUser":{"userID":459,"name":"Jim Hook","url":"https:\/\/community.smartsheet.com\/profile\/Jim%20Hook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9d\/28\/n9d28abcc5c5c53d330f96b33667ff30d.png","dateLastActive":"2022-08-19T17:24:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":6,"countViews":2344,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/86\/how-can-i-conditionally-update-a-cell-but-leave-the-current-value-there-if-the-condition-fails","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/86\/how-can-i-conditionally-update-a-cell-but-leave-the-current-value-there-if-the-condition-fails","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":68,"type":"discussion","name":"Formula question","excerpt":"Hi Smartsheet community! I realize there is a help area for this but I have looked ... read.. googled.. till I'm blue. So this is new and I thought in this NEW COMMUNITY maybe I could shout out for some help. I am trying to do a formula so that the smartsheet can look at a month ( column ) and then determine in another (…","categoryID":317,"dateInserted":"2015-04-05T22:13:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-07T14:35:57+00:00","insertUserID":337,"insertUser":{"userID":337,"name":"Stephanie Estes","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Estes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-14T16:15:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":337,"lastUser":{"userID":337,"name":"Stephanie Estes","url":"https:\/\/community.smartsheet.com\/profile\/Stephanie%20Estes","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-08-14T16:15:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":52,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/68\/formula-question","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/68\/formula-question","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/community.smartsheet.com\/sites\/all\/libraries\/tinymce\/jscripts\/tiny_mce\/plugins\/emotions\/img\/smiley-laughing.gif","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Laughing"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}]},{"discussionID":55,"type":"discussion","name":"Alert for RYG's","excerpt":"One person is wanting to be notified when their RYG ball turns green, which means a document they are needing is complete. In the notifications, I can only choose for her to be notified when that column changes for anyone. Is there a formula I can do that will accomplish this? Blessings, Loann","categoryID":317,"dateInserted":"2015-03-17T16:23:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-04-07T12:19:00+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","title":"Broadcast Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-08-24T22:01:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":254,"lastUser":{"userID":254,"name":"Loann McGee","title":"Broadcast Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-08-24T22:01:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":4,"countViews":83,"score":null,"hot":4,"url":"https:\/\/community.smartsheet.com\/discussion\/55\/alert-for-rygs","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/55\/alert-for-rygs","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":492,"urlcode":"media-entertainment","name":"Media & Entertainment"},{"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":27,"type":"discussion","name":"CHILDREN formula in another cell.","excerpt":"I am trying to SUM the indented children rows in another cell that isn't the parent. Is this possible?","categoryID":317,"dateInserted":"2015-02-24T14:51:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2015-02-25T15:32:02+00:00","insertUserID":199,"insertUser":{"userID":199,"name":"Taylor F","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20F","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/26\/0c\/n260ce7cbd81299b26217e02faf98d56f.png","dateLastActive":"2022-06-29T17:34:21+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"updateUserID":null,"lastUserID":198,"lastUser":{"userID":198,"name":"SoniaR","url":"https:\/\/community.smartsheet.com\/profile\/SoniaR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-05-03T12:16:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":36,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/27\/children-formula-in-another-cell","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/27\/children-formula-in-another-cell","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":317,"name":"Archived 2015 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2015","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}">