-
Change Sheet Summary Field Name from Sheet Summary Report
We are working on a client project. We have 15-20 summary fields and we want to create 5-6 more. The problem is if we add exact names of 5-6 fields, it will take hours to finish it. What we want is to name those fields as 1,2,3,4,5,6 and save it quickly. After this activity, we can. create a sheet summary report and change…
-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Automate Group membership management
Idea is to automate group management based on some users' information like: email domain Licensed/unlicensed Active/Inactive User description or attribute that can be used to enter text to be used as filter And also schedule report to send group membership to group owner.
-
Full Screen View Default for Published Report Widgets
I would like to have an option for reports that when it is published, I can default it to full screen view. Currently, you would have to manually click the expand button to remove the top blue bar. "Normal" View: The below icon will expand the report to full screen view. I want this to always display the widget in full…
-
Please create a warning/error message for Sharing discrepancies
If a user is assigned sharing to a report (e.g. editor, cannot share) but does not have equivalent or greater sharing privileges in the base sheet (e.g. they are only a viewer) the user will have issues making changes in the report as expected… The owner/admin then has to remember to look for this underlying…
-
Email Report Summary of Tasks at risk - ONLY IF 1 or more tasks are "At Risk"
Hi, I have a colum "at risk" in my sheet, id like to set up a report that sends to summarise all items at risk, i have the report set up this is really simple and no issue. How do i go about restricting the report to only send if 1 or more items meet the criteria, rather than sending a daily blank report and me having to…
-
Want Dashboard to Update with Data Live Based on Report
Hi - I want a dashboard I have created to update with data live based on the report I have input into the dashboard. Is this possible, by which I mean can a sheet update live based on a report so the metric widget reflects those numbers? If not, what are other solutions, and if a formula is needed can you give me the…
-
Free Text Field for Location in Smartsheet
Is there a way to create a report and widget for a dashboard that will illustrate the number of requests per location based on form that is free test?
-
Creating a graph from 3 variables
Hello, I would like to create a graph in SS from using three variables: CSP name, Observations (Critical, Major and Minor) and Categories (findings). Please find below example: I did create report from the sheet and tried to create Chart in Dashboard, but it says "Selected data can not be charted, please select a new…
