-
Set Current Workspace as Default location when selecting "Source Sheets"
I think everyone will agree that they would like it if when selecting a report's "Source Sheets", that Smartsheet should use the current Workspace as the default location to find the data it should use in the report. Currently, it looks in the "Sheets" folder, which for some of us is miles away from where we want to be.…
-
Formula based of portfolio report
Hi, I would like to do a simple count and countif based of my portfolio report. But when I start the formula and want to link to the report, it is not available for selection. I am the admin/owner of the report. Is it just not possible to use a portfolio file for formulas?
-
How to Automate workflow to create a summary report to diff between two excel sheets on weekly basis
Using SmartSheet, I want to be able to import excel sheet from sharepoint on weekly bases lets say "week 09" excel sheet name is [TC Roadmap 25ww09 VTS] Then I need to add to end additional +5 columns, these column includes formula(s) which I use to massage data coming from original data to create reports After a week ,…
-
Column descriptions
Hello, Why i do not see Column Descriptions in the Report? thanks!
-
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…
-
Assets and Workspaces Use - Dashboard reporting
Anyone familiar with the Admin center has the chart that displays the total asset count per account (workspaces, sheets, reports, dashboards) pictured below. I'd like to generate a month over month view of these metrics on our company dashboard to show the growth/use of Smartsheet for our leadership team. We are newer to…
-
Needing to update Summary Sheet mapping
Hello, I am thinking this is an easy question with an easy solution. I have a Control Center blueprint where I have mapped a column incorrectly, Text instead of Contact. The data is coming from the metadata file, which is linked in from the project. Is there an easy way to change the cell linking on the Summary sheet? I…
-
Monthly Summary Report Without Daily Data
I have a report that I use to take daily numbers, and it will output a monthly summary. At this time reports are not optimized to be able to grab that data and just give me a monthly summary. I have no choice but to have that daily data in the report. I have over 26 different sets of numbers, so it fills up quickly and I…
-
Cell Referencing Report
A report which would provide the list of cells that are being referred from another sheet with details
-
i am not able to sort in smartsheet reports when Multiple source file(sheet) is selected?
I am trying to sort based on the YTD summary, which is a numerical value, but Smartsheet won't allow me to sort it, it sorts automatically based on the alphabetical order which is available on primary column. Anyone faced this issue or have any solution for this?