-
The new Report - missing " remove formatting" - search not working well
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. Where is that option, now? 2) It seems a report now has a max of 500 lines. I wanted to search my report for an item but it…
-
counting multiple select column
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 and I figured that out by doing a =COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT")) My issue is that…
-
Centrally managed column values? Multi-project rollup?
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 flexibility of Airtable to fit SmartSheet's more typical enterprise app structure. Questions: Does SmartSheet have a concept…
-
Conditional Formatting - Report
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 highlighted red. I've tried to set up a helper column but can't find a formula that refers to if the cell is a specific color. Any…
-
How can I create a Report that pulls data from both rows and the summary of multiple sheets?
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 have a single row in each sheet for the data that changes month to month. e.g. Current spend to date. What I'm looking for is…
-
Can I make a person an Admin on a report but make them only as an Editor or View on base sheet?
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 view and edit information the report but I don't want them to have access to edit or share the base sheet.
-
Highlight Changes on Dashboard
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 Report. Anytime there is a new entry added to the Sheet through the form, it turns the data yellow. Unfortunately, this…
-
Include Attached Document in a report
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 title ROW 1 based on a where clause for Example "Client Name - Project Schedule". In the actual ROW I have included the…
-
Forecasted Project Progress
I would like to be able to create a graph that show forecasted percent complete over time (assuming activities are completed on time). This is daily and in the future. I assume this could be a report Something like: * Day 1 Projected Earned Value = 0% * Day 2 Projected Earned Value = 0% * Day 3 Projected Earned Value = 0%…
-
Can we get a new ETA for the report builder updates?
Hi Smartsheet Employees, This published dashboard by smartsheet shows that the Report features announced at Engage were supposed to be out in October. Is there a new ETA for these features? I am looking forward to them!
