Archived 2017 Posts

TODAY(), \"Gray\"))) What I would like to accomplish past this: Yellow if 5 days prior to Finish Geen if 6 or more days prior to finish Gray if…","categoryID":319,"dateInserted":"2017-01-06T09:12:21+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T13:01:44+00:00","insertUserID":10170,"insertUser":{"userID":10170,"name":"Nick Johnson","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-05T09:13:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10170,"lastUser":{"userID":10170,"name":"Nick Johnson","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-05T09:13:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":2,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6898\/setting-rygg-based-on-2-columns","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6898\/setting-rygg-based-on-2-columns","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}]},{"discussionID":6891,"type":"discussion","name":"Merging MS Project information into SmartSheet Project","excerpt":"I manage a number of projects using SmartSheet for my company. We employ multiple subcontractors and vendors on these projects who use MS Project to manage their activity, but we report on the aggregate project inside our company with SmartSheet. I receive regular (weekly), updated MSP files from the subcontractors, and…","categoryID":319,"dateInserted":"2017-01-05T12:24:27+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T11:14:25+00:00","insertUserID":10176,"insertUser":{"userID":10176,"name":"Dennis Wierzbicki","url":"https:\/\/community.smartsheet.com\/profile\/Dennis%20Wierzbicki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7InP-9yKSz4!jIfOI_zEyz4!Aqfk02j00fn","dateLastActive":"2021-10-27T13:47:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":10176,"lastUser":{"userID":10176,"name":"Dennis Wierzbicki","url":"https:\/\/community.smartsheet.com\/profile\/Dennis%20Wierzbicki","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!7InP-9yKSz4!jIfOI_zEyz4!Aqfk02j00fn","dateLastActive":"2021-10-27T13:47:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":252,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/6891\/merging-ms-project-information-into-smartsheet-project","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6891\/merging-ms-project-information-into-smartsheet-project","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":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":6897,"type":"discussion","name":"Nested ISBLANK Formula issue","excerpt":"Hi all, I've having some issues with the formula below and was wondering if anyone more knowledgable than I could take a look for me. I don't get an error message I just get a blank cell which is actually worse than an error message. =IF(ISBLANK([WPA2]47), [WPA1]47 + [>30PEE]47, IF(ISBLANK([WPA1]47), RCM47 + [>30PCM]47,…","categoryID":319,"dateInserted":"2017-01-06T06:57:07+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T09:25:07+00:00","insertUserID":8358,"insertUser":{"userID":8358,"name":"James Maxwell","url":"https:\/\/community.smartsheet.com\/profile\/James%20Maxwell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-05-15T22:00:23+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":1,"countViews":41,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6897\/nested-isblank-formula-issue","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6897\/nested-isblank-formula-issue","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}]},{"discussionID":6896,"type":"discussion","name":"Hiding data in my project plan for specific users","excerpt":"Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3\/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…","categoryID":319,"dateInserted":"2017-01-06T04:07:57+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T08:51:27+00:00","insertUserID":8067,"insertUser":{"userID":8067,"name":"Yovanka Barnard","url":"https:\/\/community.smartsheet.com\/profile\/Yovanka%20Barnard","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2017-09\/fc\/2a\/nfc2a39c295d41b5b2b3a1fdeada75e9b.jpg","dateLastActive":"2018-06-07T13:13:03+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":1,"countViews":22,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6896\/hiding-data-in-my-project-plan-for-specific-users","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6896\/hiding-data-in-my-project-plan-for-specific-users","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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":273,"urlcode":"Security","name":"Security"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"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":6894,"type":"discussion","name":"Enhance Reports to allow selection criteria that compares two fields within a row","excerpt":"Hi There, I would love to see the reports tool enhanced to allow me to show records where the Projected Closure date on a row is less than end date. We link a field from a planning\/revenue projection sheet that shows when the project will be billed with the actual end date of the project from within its project plan. If…","categoryID":319,"dateInserted":"2017-01-05T18:57:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-06T08:42:43+00:00","insertUserID":9156,"insertUser":{"userID":9156,"name":"Cindy Mooney","url":"https:\/\/community.smartsheet.com\/profile\/Cindy%20Mooney","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-03-07T12:56:16+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":1,"countViews":11,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6894\/enhance-reports-to-allow-selection-criteria-that-compares-two-fields-within-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6894\/enhance-reports-to-allow-selection-criteria-that-compares-two-fields-within-a-row","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":249,"urlcode":"Education","name":"Education"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":391,"urlcode":"product-development","name":"Product Development"}],"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":6890,"type":"discussion","name":"Commission sheet","excerpt":"I'm looking for a Sales Commission sheet that tracks sales, commissions earned, etc. We have a junior salesman and a senior salesman who produces and earns overrides on the junior. Much appreciated if you could share one or perhaps a screenshot to get me started.... Thanks - Scott","categoryID":319,"dateInserted":"2017-01-05T10:37:29+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-05T15:21:46+00:00","insertUserID":9821,"insertUser":{"userID":9821,"name":"scottlove","url":"https:\/\/community.smartsheet.com\/profile\/scottlove","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ng9P38SRFno!uiNPpxSwmHo!IF7x4CrHDr6","dateLastActive":"2021-06-01T20:11:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":2858,"lastUser":{"userID":2858,"name":"Brett Evans","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Evans","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-01T19:43:29+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":153,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6890\/commission-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6890\/commission-sheet","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":210,"urlcode":"Human Resources","name":"Human Resources"}],"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":6892,"type":"discussion","name":"Can Smartsheet show a Gantt style bar that shows monthly RAG status trend?","excerpt":"I am new to Smartsheet and have a POC developed in Excel that allows us to have a gantt style timeline that is coloured by month according to the monthly RAG status. This RAG status is conditionally formatted based on whether we indicate 1, 2 or 0 in the cell but is not shown. We can also add activity descriptions in the…","categoryID":319,"dateInserted":"2017-01-05T13:19:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-05T14:55:56+00:00","insertUserID":10178,"insertUser":{"userID":10178,"name":"Simon Godden","url":"https:\/\/community.smartsheet.com\/profile\/Simon%20Godden","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-02-07T05:43:41+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":1,"countViews":176,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/6892\/can-smartsheet-show-a-gantt-style-bar-that-shows-monthly-rag-status-trend","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6892\/can-smartsheet-show-a-gantt-style-bar-that-shows-monthly-rag-status-trend","format":"Html","groupID":null,"statusID":0,"image":{"url":"\/sites\/default\/files\/Capture_31.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Untitled"},"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":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":279,"urlcode":"Marketing","name":"Marketing"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"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":6888,"type":"discussion","name":"Using Percent Value to Set Dropdown","excerpt":"I am trying to use a formula to set a dropdown value based on the percentage value. Here is the formula I am using: =IF([Percent Complete]7 = 0, “Not Started”, IF([Percent Complete]7 < 0.26, “Just Started”, IF([Percent Complete]7 < 0.74, “Working”))) I am setting the formula in the dropdown cell and continue to receive…","categoryID":319,"dateInserted":"2017-01-05T09:39:31+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2017-01-05T13:59:52+00:00","insertUserID":10170,"insertUser":{"userID":10170,"name":"Nick Johnson","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-05T09:13:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":10170,"lastUser":{"userID":10170,"name":"Nick Johnson","url":"https:\/\/community.smartsheet.com\/profile\/Nick%20Johnson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-05T09:13:09+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":92,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/6888\/using-percent-value-to-set-dropdown","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/6888\/using-percent-value-to-set-dropdown","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}">