-
How to have users only able to see and edit rows assigned to them?
Hi We have a number of sheets spread over different workspaces. We only want the users to be able to see and edit tasks allocated to them. We do not want them to be able to see information on sheets that is allocated to others. Initially I thought that I could set up a sheet(s) and allocate rows to a specific user. I was…
-
View options of Reports in mobile devices
Hi On a mobile device, the view options of Smartsheet Reports should be the same as those given in the view options given in the Sheets. Viewing the Reports at present is very inconvenient, in the absence of these View options (found in the Sheets). Please see the screenshots below for reference. Report View options (on a…
-
Using Get Report activity in UiPath throws API error
In a UiPath automation, I am trying to get the contents from a report based on summary data from all sheets in a specific folder. I set up the scope and added the Get Report activity with the report ID from the target report. When I run the activity to test it it returns an error: "Error Code: [202] \r\n Message: The…
-
Joint Report (like joint query)
If I have a project and roles in each project. So, if I have a project details sheet, and project ID to role details sheet. Each project many have many rows in the role details sheet. Can we have a way so we can merge the two sheets in the reports so each row displays the columns based on where that column is coming from…
-
Report Filter - Can you filter one column against another or a summary field
In the report filter, can you compare the value in one column against a summary field or another column? For example, I am building a report that needs to pull data from a sheet for rows that were created in the previous month. This report will be going into a dashboard and will need to be updated every month. At this…
-
How to count total checked in report instead of just total number in report?
I am trying to use the report to summarize some data to ultimately put in a Dashboard. In the screenshot I am actually trying to count the total number of T4C completed which would be indicated by the check mark. Instead it is currently counting the total number in the report, checked or unchecked. I am using a report for…
-
Report not visible to person who has Editor/share access
Hi, I didn't want to give a person access to my sheet so, I said I would create a report for them with the information they would want to see from the sheet. I did so and shared it to them with Editor/share permissions, but when they access the report, they don't see any data. What could be the reason for this? They don't…
-
No Drop Down entry for the week
I am looking for a formula to indicate if there are no entries of an item in a drop down menu within a particular week of the year. Below is a brief rundown of what I have accomplished, and what I desire. I am looking to create a report or dashboard to reflect if an inspection on a particular device has been completed for…
-
Creation Date Report
Hi All, I'm looking to create a report that will allow me to source the creation date of all my sheets. I've tried googling but all reports lead me to last edit dates rather than the original sheet creation date. Any assistance would be greatly appreciated. Thanks, Evan.
-
Merged: Formatting within a Report
This discussion has been merged.
