Sheet Summary

…","categoryID":322,"dateInserted":"2023-02-15T17:56:41+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T19:06:09+00:00","insertUserID":137886,"insertUser":{"userID":137886,"name":"Harvey E","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Harvey%20E","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-07-25T15:15:26+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-26T00:32:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":75,"score":null,"hot":3352973570,"url":"https:\/\/community.smartsheet.com\/discussion\/101191\/is-today-supported-as-a-sheet-summary-field","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101191\/is-today-supported-as-a-sheet-summary-field","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-15T18:52:16+00:00","dateAnswered":"2023-02-15T18:50:19+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":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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":101188,"type":"idea","name":"Include Sheet Summary fields in Row Reports","excerpt":"I've seen several queries about this, and workarounds but can't find a suggestion so here's one! I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out \/ summarise the entries per sheet. The only field I can use is \"sheet name\" which is the same for all, but what I…","categoryID":349,"dateInserted":"2023-02-15T17:32:28+00:00","dateUpdated":null,"dateLastComment":"2023-02-15T17:32:28+00:00","insertUserID":137886,"insertUser":{"userID":137886,"name":"Harvey E","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Harvey%20E","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-07-25T15:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":137886,"lastUser":{"userID":137886,"name":"Harvey E","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Harvey%20E","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/nWVKDFTEFOKBN.png","dateLastActive":"2023-07-25T15:15:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":77,"score":2,"hot":1676482948,"url":"https:\/\/community.smartsheet.com\/discussion\/101188\/include-sheet-summary-fields-in-row-reports","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101188\/include-sheet-summary-fields-in-row-reports","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]},{"discussionID":101056,"type":"question","name":"How to Calculate Percent Complete in Sheet Summary","excerpt":"My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N\/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…","categoryID":321,"dateInserted":"2023-02-13T18:07:02+00:00","dateUpdated":"2023-02-13T19:51:45+00:00","dateLastComment":"2023-02-14T20:10:14+00:00","insertUserID":156897,"insertUser":{"userID":156897,"name":"KD_HUM","url":"https:\/\/community.smartsheet.com\/profile\/KD_HUM","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-20T13:55:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":156897,"lastUserID":156897,"lastUser":{"userID":156897,"name":"KD_HUM","url":"https:\/\/community.smartsheet.com\/profile\/KD_HUM","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-02-20T13:55:24+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":594,"score":null,"hot":3352718236,"url":"https:\/\/community.smartsheet.com\/discussion\/101056\/how-to-calculate-percent-complete-in-sheet-summary","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/101056\/how-to-calculate-percent-complete-in-sheet-summary","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-02-15T11:54:44+00:00","dateAnswered":"2023-02-14T14:10:48+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":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"}],"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}">

COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
Formula Help Please - Sheet Summary
Hi everyone - I have a GIANT sheet I'm working with that contains our project portfolio. I need to add summary fields to capture Project Status (from a dop down field in a column) across 10 different Sponsor Divisions (also in a drop down field within a column). I can't seem to crack this one. Can someone help? I'm sure…
Display 2 dates in one sheet summary field
can I display both a start date column and end date column value in ONE sheet summary field IE start date column in sheet 11/7 end date column in sheet11/14 Sheet Summary field 11/7-11/14 Help please :)
Showing Sheet Summary Data in Another Sheet?
I am building SheetB to compare my budget by categories (data entered manually for now) against my actual expenses (entered in SheetA - totals for each category are part of my Sheet Summary data). Is there a way to reference those Sheet Summary totals in SheetB? Ideally, I will then be able to use SheetB to create charts…
CountIf Date formula compare different date columns
I have 3 date columns: Start Date, Draft Due Date, Final Due Date The date columns are all initially auto-set to the same date; professionals are to subsequently update the Draft and Final due dates to a later date. I would like to count the ones that never get updated, i.e. Draft Due Date = Start Date. By the filters…
Access a Sheet Summary field from a different sheet?
I have 2 sheets and want to be able to pull the value from a sheet summary field on Sheet A into a cell in the grid of Sheet B. Is there a way to directly reference this? I know how to cell link from a grid cell of Sheet A into Sheet B but not summary field. I guess I could set up a helper column in Sheet A to pull in the…
Creating a survey & collecting feedback for a list of submissions
I've created an intake form and sheet to collect project request submissions, and now need to create a way for the project committee (8 members) to score each submission using a simple 4 value Impact/Effort score that I'd like to present in a Survey Form so I can collect the data and consolidate for presentation on…
Is TODAY() supported as a Sheet Summary Field?
I am trying to get a sheet summary field on my project plan to count the number of tasks which have fallen behind plan. However I do this, I am using the TODAY() function, either in a sheet column or in the summary field itself. Here is one example of something I tried in the sheet summary field: =COUNTIFS(Status:Status <>…
Include Sheet Summary fields in Row Reports
I've seen several queries about this, and workarounds but can't find a suggestion so here's one! I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out / summarise the entries per sheet. The only field I can use is "sheet name" which is the same for all, but what I…
How to Calculate Percent Complete in Sheet Summary
My sheet is used as a task checklist for projects. It currently has a 'Status' column for each Child task with 4 dropdowns (Not Started, In Process, Complete, N/A). I am trying to create a percentage in Sheet Summary that calculates the number of fields that are marked 'Complete' in the selected cells. Pulled this formula…

Sheet Summary

Discussion List