-
Summary Sheet Not Connecting to Correct Column
I have a summary sheet set up for my projects, which is connected to a metadata sheet I have. In the metadata sheet, I have column types for different types of data (contact, text/number, date, etc). In my summary sheet, the columns that should be looking at the text/number column for data are looking at the contact column…
-
Update sheet summary field via a report
I am using row reports and sheet summary reports. When I create a row report , I can edit fields in the report and it updates back into the plan /sheet itself. This makes it easy for me to meet with a team member and review only their tasks across my plans and update % complete etc. Similarly, I'd like to be able to pull…
-
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…