-
Published report views from Dashboards
I have published a Dashboard to non Smartsheet users, that contains a number of reports added as separate widgets. When I click on these widgets as a Smartsheet admin (and creator of the report) I get into each report. I published each report also. The source data of the reports is not published though. When I give the…
-
Sum of a Cell Range, Dependent on a Dropdown Value
Is there a way to add up the total of a cell, dependent on the drop down value of the row? For instance... I would like to total the sum of the revnue (shown in the "Live Revenue Log") by the day (shown in the "Daily Revenue Overview")
-
Show dates beyond 90 days
We need to report on Jobs that has not been touched in the last 90 days. When we start a new Job we copy 4 "template" rows which include dates in the future. When I run my current report, it looks for dates on the parent row, but this row is showing the oldest date for the children. If a job has not been touched for over…
-
Multiple selections from drop-down list, enhance database function
I saw this in a thread from 2015 but wanted to re-start it. Would love the option of being able to select multiple items from a drop-down list. This is handy for improving the database functionality. Many times I have sheets with dozens of projects/rows, and I need to list multiple values for a single attribute, then query…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Exclude sheets from reports based on sheet name?
Is there a way to automatically exclude sheets from reports if the sheet name contains a certain string?
-
Export to MS Project (XML) - Greyed out
The function - Export to MS Project (XML) - is no longer working Has it been taken out of my subscription and have to upgrade or someting?
-
Calculating the Number of Tickets Opened
Hi There, I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week. Is there a formula that I can use to achieve this.
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
How to link a column to another sheet so I can run a formula on duplicate values?
Is there a way to link a whole column to another sheet? I need a whole column linked, not just cells. Copy and pasting 500 cells at a time is not going to work, as it will not update if rows are added or deleted. I considered a report, however that would only accomplish part of the job, as I want to filter the results. I…