-
Child row and Multi- contact cell selections
I am currently developing a portfolio management system in Smartsheet to centralize our work. To accommodate multiple project owners, we are utilizing a multi-select contact cell. When a user is assigned as an "owner," the initiative appears on their individual summary sheet. However, we have encountered a challenge: in…
-
Quickly delete Sheet Summary
HI there! I think that I already know the answer to my question but I am hoping that the Community will tell me that I am wrong 😊 Is there a way to quickly delete ALL of the fields in a Sheet Summary without having to select the kebab and the scroll down to "Delete Field" for each individual entry? Here's where I am at: I…
-
Dashboard Last Updated Date
I would like to display the last time the dashboard was updated. My approach was adding a date field in the summary data that automatically pulls the last saved date of the sheet. I don't think I can do a formula in the date field type. Any other suggestions?
-
Is it possible to reference a cell or summary field in a column formula?
At the top of our templates we have a Summary section where project (deliverable) details and key people are specified. I am wanting to reference the 'Deliverable Sponsor' cell within a hidden column on the sheet so we can create reports pulling through all row data across all deliverables that belong to that Sponsor. From…
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
How to setup auto rollup subtask ?
I have created a new column with % and number. It not rollup calculation.. How can I configured it? Please advise
-
Tracking Which Reviewers Have Not Submitted Forms Across Multiple Sheets
Hi Smartsheet Community, I’m looking for some help setting up a way to track reviewer submissions across three different sheets. Here’s the setup: We have three sheets (one for faculty, one for students, and one for scholarships). Each sheet lists applicants, and in each row we assign three Selection Committee (SC) members…
-
Increase summary field limit (>300)
Hi, I'm running into another Smartsheet limit. This time on the number of fields in a sheet summary. I have about 150 fields so far and I will need more than 300, most likely. But I get this warning: Can this maximum number be increased?
-
Troubleshooting Sheet Summary "INVALID DATA TYPE"
Hoping that the community can explain this issue I cannot solve (nor can AI). Today we added a Y2026 Savings column to our sheet. Column formulas were all updated as well to look for values with "effective dates" in their corresponding years. Sheet Summary (for Dashboard) formulas broke returning "INVALID DATA TYPE". Tried…
-
Error when Referencing another sheet
I have created a summary sheet that uses a formula to build out, and I am having an error when trying to reference another sheet. I have done this in the past, and it has worked. It seems to be a bug, but I wanted to confirm.