-
Report Grouping Summary Rows in Dashboard & Attachements
Is there any update on when reports might keep the grouping/summary rows when sent as an attachment or displaying on a dashboard? I remember hearing this was 'in the works' back in February.
-
Change summary email
There's an email that contacts on a sheet receive towards the end of the day when changes are made to a sheet. They'll receive the automated emails set up on the sheet as well as this summary of changes email. Is there a way to modify this email?
-
Sheet Summary with combined date fields
I'm trying to build a Summary field that pulls in the StartDate and EndDate. I'm using this formula: =[Start Date]# + " - " + [End Date]#. Does bring in the data from the two fields, but it includes the time as well as the date: "12/09/24 8:00 AM - 12/13/24 4:59 PM" Question: can I get this data with just the dates:…
-
Needing to update Summary Sheet mapping
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the metadata file, which is linked in from the project. Is there an easy way to change the cell linking on the Summary sheet? I…
-
Display values from a row when a value in that row is a specific value
I am trying to create a reporting dashboard that displays elements of a row when a value in that row is "Yes". For example, if a workstream is blocked, the reference cell is "Is Blocked?" and if the value is "yes", I would like to display on the report the details of the workstream, the owner, and the reason it is blocked.…
-
COUNTIFS formula error
I am trying to calculate training sessions based on 2 columns : status column and year column. I've done this numerous times before however for some reason no matter what status filter I choose the outcome is 0 when there are definitely values for 2024 completed training sessions. This is the formula I am using =…
-
Viewing a Smartsheet form submission in the form it was submitted through
I've created a form for project request submissions and want to view the submissions in the same form it was submitted on. This would make the submissions easy to review and work on. The grid view is not conducive to displaying several sentences of description/comments in and a different view is needed. How can I…
-
Smartsheet summary formula
Hi All I am trying to create a smartsheet formula for the Summary field that will return the maximum someone in a Senior Quantity Surveyor role is being paid currently in the company, plus the name of the person. I have the max salary part sorted - =MAX(COLLECT(Salary:Salary, [Job Title]:[Job Title], "Senior Quantity…
-
Formula Help
Hi - I need help with a formula for a sheet summary field. 1. Open Tasks that are due in the next week. I want to capture a status that does not contain "Complete" and then if the task is within the next 7 days. 2. I also want to capture the count of open tasks that are overdue - i.e., in the past. Thank you!
-
Can I use Summary fields in formula
I have created some sheet summary fields to count the number of records that meet a specific criteria e.g. Fire Doors - Pass is the summary field and the formula is =COUNTIFS([Last Month]:[Last Month], ="True", [Fire Doors]:[Fire Doors], ="Yes") I have done the same for several other fields too e.g. Fire Exit Routes -…