-
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!
-
Sheet Summary Report From Smartsheet Into Appsheet
Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet. The error I'm receiving... The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in…
-
SUMIFS & FIND functionality with Summary Sheets
Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are "Cost Savings" or "Risk Management". I am also trying to create a formula for just…