-
% Planned formula
Hi to all, I need to add a % Planned to my plan. I used a formula but it didn't work. Attached you have a screenshot of my plan with the formula and the dates columns. Thanks for your advice!! Adelina
-
Find reports using a particular source data?
Is there a way to find all reports that use a particular sheet as source data? We have one giant sheet that is the mother of all our sheets, and we plan to make substantial changes to it but first want to know what reports are hanging off it. We want to quickly and easily find all impacted reports and resolve any issues.
-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
-
Huge Sports Event in planning
Hey guys. I am just starting to setup a sheet for a huge sports event that shall provide all relevant info, but also be used live to update the onsite status. Basically there will be about 10 stations that will be identically except for individual timings and some details (i.e. number of people per team). My client does…
-
Dashboard Chart Formatting
I currently have a chart on a dashboard displaying information from a certain range of data. If I change what data is being selected, it reverts to default formatting (e.g if I select different data for a stacked bar chart, it reverts to a non-stacked column chart and all the colors per series return to default colors as…
-
Highlight If Older Than 'X' Days
I'd like to use conditional formatting to highlight a row or cell if it's older than 30 days. It's helpful for us to see which tasks are stale. However, there's only an option for "In the last 'x' days" or "older than (a date)". Has anyone found a good workaround or submitted this as a feature request?
-
Month Function
Hello, I am trying to figure out how to extract months out of a grid. My goal is to count how many assignments were completed within each month of the year. e.g. | January | 45 | --------------------- | February| 20 | However, I am finding trouble actually calculating the amount based off of the creation date. I figured a…
-
Removing Parent Rows from a report
Hello everyone, I am using Smartsheet to manage several projects, all on individual sheets, with a high level role up for managers. We are trying to create a report that goes through all of the projects in a certain workspace and looks for tasks that are past their due date, then outputs the project name, task and who it…
-
Dynamic Sum from Multiple Sheets in a Workspace
Hello, I have a workspace full of our active projects. Each tasks has a status (not started, in progress, complete) and I would like be able to see the total numbers of these tasks statuses across all the projects. I already have columns that count the number of each task status in the individual projects, but I would like…
