-
View if sheet is referenced in a report or dashboard?
I am cleaning up the numerous sheets I've created. However, how can I see if the sheet is referenced in a report, dashboard, other? I do not want to delete a sheet that is in use.
-
Is there a way to populate a Report based on Project or owner?
I'm trying to create a report based on projects and owners. For example, I might have ten projects and multiple owners of each project. I can populate the project list but cannot find a way to include Owner My steps so far: Create Report Sheet Summary report Select projects I'd like to include, this could be single or…
-
Creating project in Resource Management from a Smartsheet Report
Hi All, I would like to get data from a client's Smartsheet into Resource management, however their work is not formatted properly for me to be able to do so. In addition, there are rows of info that are not relevant to my team. I could make a report to pull the data I need, but I cannot create a project for Resource…
-
Generating a Report based off Filter Criteria
Hi All, I am attempting to generate a report off of a filter criteria in the main sheet. It is is a live document and we work off specific filter criteria's per person, but I want to generate a report based off the circled "Current Renewals" only, but when I go to to generate the report, the report takes all historical…
-
How do I get a Dashboard Chart Widget to display 'No Data' when the source report returns no data?
I have a dashboard chart widget whose source data is a report on a sheet. There are times when the report accurately returns no data from the sheet that meets the reporting filter criteria. In that case, the dashboard chart widget displays an 'Unable to display chart' error (screenshot below). This error message is…
-
Smartsheet Calendar Column and Task Names color not aligning
Hi there, I'm currently pulling 4 separate grids into a single report to create a collision calendar. The calendar is color coded by sheet name. I recently added the 4th grid into the report and now the colors are not aligned. I created the custom colors by Sheet name previously but I cannot recall how to fix. When I go to…
-
Allow formulas to function in reports
Currently formulas do not update while in a report. If a value changes, you must refresh the report or window to see the updated formula. This creates a lot of confusion since we use reports to gather updates, which results in me being told "your smartsheet is broken" because the formula columns do not update.
-
Allow users to export a report from a WorkApp
Allow users to export a report from a WorkApp
-
Can a report be directly exported from a WorkApp?
Can a report be directly exported from a WorkApp?
-
Project Collaborators Schedule Report
Hello everyone, I hope you're doing well. I'm new to SmartSheet and currently working on my initial projects and automations. I have a project group and would like to create a report in the project management office that allows me to identify all the collaborators involved in each project and in which months they will be…