-
Cell Linking And Referencing Sheet Summary Fields From Other Sheet
Sheet1 has Sheet Summary fields. Sheet1 can access it's own Sheet Summary fields. A Report can access the Sheet Summary fields from Sheet1 (or any other sheet). A Dashboard Metric Widget can access the Sheet Summary fields from Sheet1 (or any other sheet). - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -…
-
Merged: Built-In Sheet Health Metrics: Help Us Monitor Limits Before They Break Us
This discussion has been merged.
-
Possible to send MS Outlook email Templates once a task is reached
I am trying to set up outbound emails to send to external parties for their deliverables, setting timelines, and forms to complete once certain milestones/tasks are reached with in a project. Is it possible to have a email template built / added and have that template pull in information from the sheet summary such as…
-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…
-
How Do You Document a Log of Notifications of Sheet Changes
One complaint that I am getting back from shared users of a sheet is that many times they don't know when something has changed. I can certainly make this manual task outside of the Smartsheet but I'd really like it to be captured in the sheet. For instance, I could use "File --> Email Shared Users" as the method to create…
-
How to Automatically Update Rows in Smartsheet Based on Another Sheet?
I’m working with multiple linked sheets in Smartsheet and need certain rows to update automatically when data changes in a source sheet. I’ve tried using cell linking, but it's manual and not scalable. Is there a way to automate this using formulas or workflows within Smartsheet? Would love to know how others handle this…
-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Cannot get donut chart to show legend
Hi, I am trying to get a donut chart to show the column labels as the legend but I cannot toggle that option on. I am using a Sheet Summary report and have tried a regular report with the data summarized but I cannot get anything to work. It is very simple but I do not know what to do since I cannot toggle the column names…
-
Anybody Find a Workaround for Accessing Sheet Summary Fields Across Sheets?
I would like to be able to access Sheet Summary fields from sheet to sheet. You can access them from Reports as well as Dashboard Metric Widgets, but cannot access them by cell linking or references from other sheets. Has anybody found an work around? My attempt at a workaround: I tried creating a hidden column that grabs…
-
Chart Dashboard Widget using Sheet Summary data fields
It would be great to be able to use the chart widget with data held at Sheet Summary level. Appreciate that there are 2 ways around this : Create a report and chart against that Add "helper columns" to the sheet itself However, I'd prefer to reduce the number of new reports I'm creating, and keep sheet complexity lower…
