-
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…
-
Resource Allocation and Manipulation
Hi, I am new to Smartsheet and I am trying to create a view for my team where I can see all of the tasks, across multiple sheets (projects), that individual team members are assigned. In other words I want a view where I can see all assigned tasks, with task names, who the tasks are assigned to, dates, and a Gnatt chart if…
-
Showing Milestones in Sights
I use a Sight as a dashboard, so I created a report to pick up only entire schedule for each project. i.e. I have 5 "bars" in the report, represents 5 projects. And I want to show milestones with each bar. Can I do it? If so, how? Each bar is cell-linking so I can go each sheet (project) if I click and see milestones. But…
-
Reports
Good afternoon, We have shared some reports with sub contractors that we would like them to be able to edit. How do we just let them edit the report and NOT be allowed to edit/access the sheet the report is coming from?