-
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…
-
How can I preserve grouping in a report in Dynamic View?
Hi. I am linking a report to a Dynamic View. however, I want to be able to preserve the report groupings in Dynamic View. How can I do that? Thanks
-
Build report off activity log data from a Sheet
I know that I can download an activity log from a Sheet, but is there an easy way to build a report off the activity log data? I want to track metrics like # of sheet views, unique users using the sheet, usernames in the sheet, etc
-
How can you share a report without giving access to the sheet?
I have created a time tracking report for all employees utilizing a weekly form each completes. As I don't want employees viewing other's time, I created a report for each employee so they could see their own time collectively and make changes if needed, however it only works for the members of management that have access…
-
What controls the formatting of sheet names in a report?
I want to get them all consistent. I don't care if it's a really weird workaround and not a built-in feature - is there ANY way to edit whatever they are based on? Do they adopt the formatting of a particular cell or something? Thank you.
-
Overallocation flag in sheets
Is there a formula or method to identify if a resource allocation flag is triggered for a given row? i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? I'm trying to figure out if there's a way to summarize all of the rows in our project sheets…