The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
I was told that once rows from a source sheet make their way to the Data Mesh sheet, there is no way to remove them. Even though the rows may no longer exist in the source sheet, you can't prevent them from showing up again in the Data Mesh sheet. My source sheet (report) is pulling from multiple projects so it's not…
There have been many requests for a more robust Data Backup/offload system because the existing system is inadequate. Smartsheet is simply not a viable option for data management in regulated spaces until: 1. Backups are more easily automated (Can't you just make a Data Shuttle checkbox to prevent replacement of previous…
Hi I have a report that is filtered by current user. The sheet contains requests people submit via a form. I have set the form that allows submissions without the user being logged into smartsheet and this appears to be now giving them a number (see screenshot of filter below) This is now causing my report filtered on…
I have a report where I want to filter all items that occurred in the past 24 hours from the moment in time of 06:00am today. Can someone help to guide me in how I would set up the filters in the report?
After some trouble with this command line string. I am getting a 1006 error even though I am the Owner of the Report and Owner of the Sheet that I am trying to insert. I can do this manually without any issues. Any thoughts? curl -H "Authorization: Bearer TOKENHERE" -H "Content-Type: application/json" -X POST…
It would be nice to be able to text-wrap the group names above the primary column so they aren't cut off.
It would be very helpful to have text wrapping on the headings that appear when you 'group by' on reports. In our case, we group some reports by project name as this is most intuitive for the users of the reports. These project names can often be several words long, and it looks really untidy when half the project name…
In addition to being able to count and sum a column in a report, I'd like Smartsheet to be able to count UNIQUE values within a group. For example, I have a report shows me all tasks from multiple projects and groups by project manager. If I try to count the Project column to see how many projects each Project Manager has…
Hello, I am trying to create a chart that shows the financial impact on a community when a change is made. Here's the backstory - I am in homebuilding and any time there is a change at a community, we associate that change with a CRF #. I would like to be able to create something that shows the change in dollar amounts per…