Construction

=DATE(2020, 9, 1), Finish:Finish, <=DATE(2020, 9, 30)) * 8 A suggested version has been…","categoryID":322,"dateInserted":"2020-08-21T15:18:51+00:00","dateUpdated":null,"dateLastComment":"2020-08-21T18:10:35+00:00","insertUserID":120384,"insertUser":{"userID":120384,"name":"Larry Bejcar","url":"https:\/\/community.smartsheet.com\/profile\/Larry%20Bejcar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-21T20:40:16+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":2,"countViews":148,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/70772\/using-ifs-statement-with-date-and-check-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70772\/using-ifs-statement-with-date-and-check-box","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-21T20:41:07+00:00","dateAnswered":"2020-08-21T18:10:35+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":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":70660,"type":"question","name":"Duration to a specific task from project start \/ counting the number of project days","excerpt":"Hello, I'm wondering if there is a function in Smartsheet by which I can create a column that displays the total number of project days from the beginning of the project (\"Project Day 1\") up to the beginning of each task. For example, the first task would start on \"project day 1,\" the last task of the project would start…","categoryID":322,"dateInserted":"2020-08-18T05:51:18+00:00","dateUpdated":null,"dateLastComment":"2020-08-19T18:50:55+00:00","insertUserID":125259,"insertUser":{"userID":125259,"name":"John Paul Stepanian","url":"https:\/\/community.smartsheet.com\/profile\/John%20Paul%20Stepanian","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-01T10:45:05+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":3,"countViews":243,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/70660\/duration-to-a-specific-task-from-project-start-counting-the-number-of-project-days","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70660\/duration-to-a-specific-task-from-project-start-counting-the-number-of-project-days","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-19T05:47:28+00:00","dateAnswered":"2020-08-18T11:45:00+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":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":281,"urlcode":"support","name":"Support"},{"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":60271,"type":"discussion","name":"Tracking % Changes Over Time","excerpt":"I have a master sheet (linked to many other, scope-specific QC sheets) that calculates % completion per task. Each row is for a different task, and each task has their own amount of steps. This information is all linked & calculated from the scope-specific sheets. Column 1 shows \"# of steps completed to date\", column 2…","categoryID":321,"dateInserted":"2019-10-15T11:59:53+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-08-18T19:24:43+00:00","insertUserID":107721,"insertUser":{"userID":107721,"name":"scristol","url":"https:\/\/community.smartsheet.com\/profile\/scristol","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-09-21T19:48:34+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":671,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/60271\/tracking-changes-over-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/60271\/tracking-changes-over-time","format":"Html","groupID":null,"statusID":0,"attributes":{},"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":265,"urlcode":"reports","name":"Reports"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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":70346,"type":"question","name":"Auto fill cell value if adjacent cell matches cell in another sheet.","excerpt":"Hello, I am working on a construction project with a lot of RFIs and would like our issue tracking logs to reference my main RFI log. All the RFIs have unique ID #s. I want the Issue tracking logs to update the RFI # once it is updated on my main RFI Log. my main log: 1st column is RFI #, and 2nd column is internal…","categoryID":322,"dateInserted":"2020-08-04T15:23:26+00:00","dateUpdated":null,"dateLastComment":"2020-08-10T12:24:24+00:00","insertUserID":124810,"insertUser":{"userID":124810,"name":"Michael Voth","url":"https:\/\/community.smartsheet.com\/profile\/Michael%20Voth","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-10-19T19:19:57+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":7,"countViews":1720,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/70346\/auto-fill-cell-value-if-adjacent-cell-matches-cell-in-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70346\/auto-fill-cell-value-if-adjacent-cell-matches-cell-in-another-sheet","format":"Rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/GDAM4QNNTMON\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-08-05T20:19:03+00:00","dateAnswered":"2020-08-05T20:09:51+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":218,"urlcode":"construction","name":"Construction"},{"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":70350,"type":"question","name":"Quality Control Record","excerpt":"Hi, I am trying to create a smartsheet to track the quality of a constructed panel. The constructed panel needs to be checked at certain points by different team members. The data needs to be stored to each individual panel. I have tried using forms to submit the data onto a sheet however if i want to add multiple columns…","categoryID":321,"dateInserted":"2020-08-04T16:04:51+00:00","dateUpdated":null,"dateLastComment":"2020-08-05T11:48:23+00:00","insertUserID":124815,"insertUser":{"userID":124815,"name":"Taylor Cartwright","url":"https:\/\/community.smartsheet.com\/profile\/Taylor%20Cartwright","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-03-11T15:03:55+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":1,"countViews":111,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/70350\/quality-control-record","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/70350\/quality-control-record","format":"Rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":268,"urlcode":"attachments","name":"Attachments"},{"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":53561,"type":"discussion","name":"Renaming Workspaces","excerpt":"Is there a way for admins on workspaces to be able to rename them, or is it only workspace or sheet owners that can do this? Since the admin has full sharing\/editing rights, it would be helpful to have them be able to do everything the owner can do so there isn't a bottleneck with every change having to go through the…","categoryID":321,"dateInserted":"2019-07-23T14:17:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-08-04T22:45:42+00:00","insertUserID":95996,"insertUser":{"userID":95996,"name":"Horace","url":"https:\/\/community.smartsheet.com\/profile\/Horace","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2021-01-28T23:33:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":124832,"lastUser":{"userID":124832,"name":"Stephan Tran","url":"https:\/\/community.smartsheet.com\/profile\/Stephan%20Tran","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-08-04T22:45:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":1737,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/53561\/renaming-workspaces","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/53561\/renaming-workspaces","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":208,"urlcode":"workspaces","name":"Workspaces"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":549,"urlcode":"account-and-user-management","name":"Account and User 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":41431,"type":"discussion","name":"Web Form Update Multiple Sheets","excerpt":"Hello, I need help figuring out how to have a web form update multiple sheets based upon location information. Basically I have put together a web form that will do a site survey of hotel rooms for renovation. We are surveying several sites at a time and instead of creating 20 different web forms that update 20 different…","categoryID":343,"dateInserted":"2019-02-13T13:23:01+00:00","dateUpdated":"2022-06-14T14:36:25+00:00","dateLastComment":"2020-07-20T15:57:11+00:00","insertUserID":78421,"insertUser":{"userID":78421,"name":"GPow","url":"https:\/\/community.smartsheet.com\/profile\/GPow","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-02-13T13:05:42+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":779,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/41431\/web-form-update-multiple-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/41431\/web-form-update-multiple-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":204,"urlcode":"forms","name":"Forms"},{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":277,"urlcode":"integrations","name":"Integrations"}],"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}">