-
Updatable fields in a report.
I have a report with several updatable fields. These are updatable in the underlying sheet. The problem is with date field. It won't allow me to update it in the report. All the other fields (4) work fine. 1 is a text, 1 is a contact list, 2 are checkboxes. Are date field not allowed to be updated in a report? If so, why…
-
automation is not working
my daily reports didn't send. i have a release report scheduled daily to send to certain people 2x a day Friday it worked - today it doesn't something different after the update from Saturday?
-
Dashboard opening position
I currently have a large dashboard which is opening about 3/4 of the way down. Is it possible to set so the first view is at the top?
-
[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…
