It seems that you cannot run a report based on a filter condition such as "Not in the past X Days", if you are having the condition look at an auto-generated date. That seems odd, because within the g…
Using the Sheet Summary function this formula worked: =SUMIFS({Budget Projected}, {Budget Account}, Variable@row, {Budget Assigned}, Employee#) when the lined was assigned to only one contact, but now…
Hello I see there have been some pretty major changes to the Report interface, recently. 1) I used to be able to "remove formatting" so the source sheet formatting didn't carry over to the report. Whe…
Hello, I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team. I want to see a total count of each status per team. That is the easy part a…
I'm a SmartSheet noob investigating whether it's possible to recreate in SmartSheet what we've done in Airtable. I'm pretty sure SmartSheet can do what we need, I'm just unclear on how to adapt the fl…
I have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighte…
I am looking to create a Report that consolidates data from multiple projects. I have a sheet for each project which includes Summary fields for each with items like Project Name and Description. I ha…
I have created multiple reports from a base sheet but do I am wondering if one person can have different access levels to sheet and base sheet. I know they need access to the base sheet in order to vi…
Hello, I have created a Sheet with a form. I have taken the data from this Sheet into a Report, and then onto a Dashboard. I have turned on the "Highlight Changes" feature on both the Sheet and the Re…
Hey team I have been using SmartSheets since day one and I continue using it. I have a question about a report that I have built. I have a report that I have built that pulls in all my projects plans …