-
Reports and Dashboards break if column is renamed in a Sheet
Reports and dashboards break if the columns in the source sheet are renamed :-( It will be great if @smartsheet does not depend on the column names from the sheet when used in reports as it will then not break the reports and hence the widgets in the dashboards using those reports as source.
-
Blank Report
I shared a report with a customer. When the customer opens the report it is blank. It doesnt show any of the data? I tried sending a link to the report as well. Still nothing in the report. The customer setup a username and password. Im obviously missing something. Any ideas as to why the data doesnt show up in the report?…
-
How to restrict rows by contact
Hi all, I am traying to create a Disciplinary Actions report where the manager can only see the inforamtion he has assigned. I have some others managers, but In the report, I want he only sees the rows that have his name.
-
View Predecessors in Reports
Is it possible to view the Predecessors in a Report? When I create a Report from a Project Schedule, it does not show the Predecessors dependant on that task, it only shows the number of predecessors. I eventually created a duplicate column and put in a formula to copy the value of the Predecessor column and use that new…
-
RTF in Dashboard Widget
I downloaded an example dashboard which tracked multiple projects. Looked good and decided to build my dashboard to match example. Example dashboard has a Rich Text Widget which has multiple formats within. However when I try to use the rich text widget it does not allow me to have varied formats (different text sizes,…
-
If a filter is active in a Smartsheet will it impact a report results?
We had a question come up from our team. If a Smartsheet has a filter applied, will it have any impact on a report that includes that Smartsheet? For example, when a Smartsheet has a filter applied that shows the tasks assigned to a current user. If that filter is active within a Smartsheet when I run a report (that…
-
Trying to combine IF, OR, & AND
Hi all, As the title states, I am trying to create a helper column that is checked or unchecked based on a few conditions. I want to check the helper column box if statements 1 and 2 are both true or if statements 1 and 2 are both false. I had written: IF(OR(AND(statement 1@row = 1, statement 2@row = 1), AND(statement…
-
Filter unable to be updated on Reports
Hello, I have a report where a user is set as the Admin but they cannot update the filters that are set to include additional conditions. The report is pulled from one sheet where they are set as a Commenter. I tested with someone else who has the same access and they can update the filter. I am sure there is something I…
-
User statistics
Hi, is it possible to get users statistics, if I can, can I have those show up on a spreadsheet? Some of these are free users. Thank you Kim
-
Filters in reports
Is it possible to filter in a row report for a field which is in the sheet summary report? I mean I need to create a row report, but also need to have a visualization based on a single field which I only have in the sheet summary report. This way it would clearly be a way to get a filter on a list of sheets to put in my…