-
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!
-
How to Consolidate Entries from Multiple Forms
I've seen this question asked before, and the same answer is always given, "use an update request." Is there a way to consolidate information, because I don't think update requests are the best solution for our process. I have multiple forms with different types of information being entered at different times by different…
-
Create Chart Widget Using a Report (not a Sheet)
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the submission is due, when it is submitted, and the number of days (plus or minus) between the two. I…
-
Reports - Publish as iCal
Is it possible to publish reports as iCal? If not, this would be a great feature.