-
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.
-
Notification and capability to create report for all broken links (Cell Link References)
When links are broken on sheets, we want to be notified and to be able to create report on all sheets in Workspace, so we can fix all broken cell links ASAP. Each team has different schedule sheets and we use cell link from one schedule to another and we depend on the dates on the schedule. Currently there is no…
-
Sum from Report
I know this has been asked but it's been a while so maybe there's been a change 😀. Is there a way to do any of the following? Use data shuttle or some sort of automation to export a report to a sheet in Smartsheet or to a Google Sheet? Use sum formula on a sheet from a workspace? (so that I can sum all project plans within…