Support

TODAY(), \"In Progress\", \"Complete\")))) When I have dates entered for Start Date, Actual Start Date, and End Date the…","categoryID":322,"dateInserted":"2022-09-27T13:44:09+00:00","dateUpdated":null,"dateLastComment":"2022-09-27T20:16:12+00:00","insertUserID":152857,"insertUser":{"userID":152857,"name":"bailey99","url":"https:\/\/community.smartsheet.com\/profile\/bailey99","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!xUMu8Tpr6Io!upNuJ7YWmzo!sYIyLIKqTzs","dateLastActive":"2022-10-20T14:22:28+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":4,"countViews":183,"score":null,"hot":3328598421,"url":"https:\/\/community.smartsheet.com\/discussion\/95944\/invalid-operation-when-using-today-in-nested-if-statement","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95944\/invalid-operation-when-using-today-in-nested-if-statement","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-27T17:02:54+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":219,"urlcode":"sheets","name":"Sheets"},{"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":95956,"type":"question","name":"Is it best to link only one predecessor to each task or is it ok to have multiple?","excerpt":"I am working on a construction schedule and wondering what the best practice is for attaching predecessors. I have noticed my Gantt chart is currently a bit all over the place and I am thinking it is because I have too many predecessors for each task. Do more experienced Smartsheet users recommend only having one…","categoryID":321,"dateInserted":"2022-09-27T17:03:42+00:00","dateUpdated":"2022-09-27T17:04:26+00:00","dateLastComment":"2022-09-27T18:03:11+00:00","insertUserID":152892,"insertUser":{"userID":152892,"name":"lbell","url":"https:\/\/community.smartsheet.com\/profile\/lbell","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-19T15:22:04+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":152892,"lastUserID":151285,"lastUser":{"userID":151285,"name":"PWNA Sam Harwart","title":"","url":"https:\/\/community.smartsheet.com\/profile\/PWNA%20Sam%20Harwart","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BJ1TQQS66sU!86nRd5yLxD0!Fqg6-EE4vDZ","dateLastActive":"2023-08-09T21:01:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":137,"score":null,"hot":3328600613,"url":"https:\/\/community.smartsheet.com\/discussion\/95956\/is-it-best-to-link-only-one-predecessor-to-each-task-or-is-it-ok-to-have-multiple","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95956\/is-it-best-to-link-only-one-predecessor-to-each-task-or-is-it-ok-to-have-multiple","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-27T18:43:00+00:00","dateAnswered":"2022-09-27T18:03:11+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":20306,"type":"question","name":"Create Chart Widget Using a Report (not a Sheet)","excerpt":"With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly \"submission date\" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…","categoryID":321,"dateInserted":"2018-02-26T13:43:40+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2022-09-27T16:02:19+00:00","insertUserID":5179,"insertUser":{"userID":5179,"name":"Pam Tadsen","url":"https:\/\/community.smartsheet.com\/profile\/Pam%20Tadsen","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OWFQO4OSOT1P\/nUVOG870WGDCQ.jpg","dateLastActive":"2023-08-24T20:35:20+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":18,"countViews":3788,"score":null,"hot":3183957959,"url":"https:\/\/community.smartsheet.com\/discussion\/20306\/create-chart-widget-using-a-report-not-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/20306\/create-chart-widget-using-a-report-not-a-sheet","format":"Html","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2020-03-03T10:37:54+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"}],"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":95916,"type":"question","name":"COUNTIF with keywords","excerpt":"Hello, I am trying to set up a formula to count a cell if it contains a certain keyword (e.g. \"communication\"). The cell itself won't be only composed of that word, but will just contain it. My formula so far is =COUNTIF([Job Classification]:[Job Classification], CONTAINS(\"communication\", [Job Classification]:[Job…","categoryID":322,"dateInserted":"2022-09-26T19:57:57+00:00","dateUpdated":null,"dateLastComment":"2022-09-26T20:58:08+00:00","insertUserID":132547,"insertUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-05T12:06:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":132547,"lastUser":{"userID":132547,"name":"Evgeniya Nazarnaya","url":"https:\/\/community.smartsheet.com\/profile\/Evgeniya%20Nazarnaya","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-05T12:06:44+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":232,"score":null,"hot":3328449365,"url":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95916\/countif-with-keywords","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-26T21:10:03+00:00","dateAnswered":"2022-09-26T20:03:18+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"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":95832,"type":"question","name":"I imputed a date that was 09.01.22 and yet the png shows 01.01.22","excerpt":"I completed a gantt chart shown here and as you can see my start date is 09.01.22 and yet the gantt charct shows january february, etc., this is ridiculous and completely ruins my chart and I didn't even input those values. If anyone could help me in removing them I would be grateful, thank you.","categoryID":321,"dateInserted":"2022-09-23T01:22:23+00:00","dateUpdated":null,"dateLastComment":"2022-09-24T01:53:47+00:00","insertUserID":152769,"insertUser":{"userID":152769,"name":"emmak","url":"https:\/\/community.smartsheet.com\/profile\/emmak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-24T01:54:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":152769,"lastUser":{"userID":152769,"name":"emmak","url":"https:\/\/community.smartsheet.com\/profile\/emmak","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-09-24T01:54:07+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":125,"score":null,"hot":3327881770,"url":"https:\/\/community.smartsheet.com\/discussion\/95832\/i-imputed-a-date-that-was-09-01-22-and-yet-the-png-shows-01-01-22","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95832\/i-imputed-a-date-that-was-09-01-22-and-yet-the-png-shows-01-01-22","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/2EP64E20691V\/homework-232-286-29.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"HOMEWORK #2 (6).png"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-09-23T05:19:35+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":285,"urlcode":"solution-center","name":"Solution Center"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"}],"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":95456,"type":"question","name":"Total Site % Complete + health","excerpt":"I need the total site % Complete Each milestone has % complete for the site project What is the sample formula to calculate each milestone % complete columns to give the site Total % complete? Let’s say, Milestone ABCDEF etc I just want to SUM all the milestone % complete to give me the total project % complete Then the…","categoryID":322,"dateInserted":"2022-09-16T19:47:36+00:00","dateUpdated":"2022-09-16T19:52:04+00:00","dateLastComment":"2022-09-23T16:19:13+00:00","insertUserID":151274,"insertUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":151274,"lastUserID":151274,"lastUser":{"userID":151274,"name":"RobNY2","url":"https:\/\/community.smartsheet.com\/profile\/RobNY2","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/175VYHRPOFFC\/nOY2XIY0BFCLX.png","dateLastActive":"2023-04-06T17:41:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":148,"score":null,"hot":3327309409,"url":"https:\/\/community.smartsheet.com\/discussion\/95456\/total-site-complete-health","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/95456\/total-site-complete-health","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2022-09-23T19:08:11+00:00","dateAnswered":"2022-09-23T16:19:13+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"},{"tagID":281,"urlcode":"support","name":"Support"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":391,"urlcode":"product-development","name":"Product Development"},{"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">