-
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…
-
Update to the Published versions of dashboards and reports
Instead of saying View Only, I would suggest an update to View of .......... This will allow that dashboard or report to be a friendly presentation instead of so rigid.
-
Using "Current User" as a filter in reports
Can you use "Current User" as a filter if the "Assigned To" field has more than one person assigned? Thanks!
