-
[Help] Non Licensed Users Having Trouble Accessing Published Report from Published Dashboard
Hi, I have a series of report links on a dashboard. Both the dashboard and the reports have the published option selected (available to anyone with a link). Non licensed users are able to access the dashboard with the link provided but are then being prompted to log in to their smartsheet account (which they do not have)…
-
Sheet Formulas Not Auto Updating
Just recently I noticed that the formulas within my sheet are not working in the background and updating my reports as they used to. I have a formula that populates a status based on a date, so if the date is in the past, it marks the status complete and then my report only pulls tasks that are not complete - I only have…
-
Clear background / highlighting colors
I added the "Modified" column to a report that feeds my dashboard. Some of the dates are highlighted yellow and some aren't. I checked the source sheets and I don't see any yellow. There was in the past, but it has long been removed and does not show up on any other reports. How do I get rid of the yellow highlighting that…
-
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?