-
Summarizing a column based on another multi select column
Hello - I have a column named "Monthly Hours" that lists hours (integers). I have another column called "Site of request" that lists the site(s). That column is multi-select. I would like to summarize hours spent per site. So, if the "Monthly Hours" column has a 10, and the "Site of request" lists "Site A" and "Site B",…
-
Formula to Capture Active Projects Assigned to an Individual ONLY
I'm currently having trouble figuring out how to capture the number of status specific projects assigned to an individual. I've attempted the "COUNTIFS" formula many times, but can't seem to configure it so that it counts the number of projects by assignee IF the project status is one of the following: Not Started In…
-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Dashboard/Report to show status change in last 30 days
Hi, I'm looking to be able to show on a dashboard a chart and detail of projects that have had a status change (RYG) in a given period of time (last 30 days). It doesn't appear that reports allows to filter on that type of data. any suggestions? Thanks! UPDATE- solved via Automated work flow using an added date column, and…
-
Visual grouping of data - input requested
Hi, looking for suggestions/tools on a way to show data visually grouped ideally without using parent/child relationships. e.g. if 5 initiatives were all tied to one larger objective, I'd like to only reflect the objective once (vs. in each row), with the 5 initiatives shown to the right. I know the calendar app offers…
-
Smartsheet labs - maps in dashboards
Hi All, Is it possible to add smartsheet maps (bing from smartsheet labs) into dashboard/sight? And if not, is there a plan to make it? BR Marcin
-
Is it possible to use a custom background on a smartsheet dashboard?
I am trying to add a custom background to my dashboard but I only have the option of grey or white?
-
Add new dashboard, sheets and reports to Existing Projects
I have many existing project toolkits that I need to add a new Dashboard and several sheets and reports to. I have tried this multiple ways and have searched for many days in the Community for some answers with no solutions found. Please tell me how I can add a new dashboard, sheets and reports to EXISTING projects. Any…
-
Bug in mobile app? Can't open sheets from summary report on dashboard
Hi, I made a summary report to collect all sheets in a folder and placed this report on a dashboard. The summary report has only one column, which shows the sheet names as hyperlinks. The idea is that one can navigate to the sheets by clicking on the hyperlinks in the report on the dashboard. On a desktop this works fine…
-
How to display just 1 specific cell of data in a dashboard?
Hi - I am looking to do some very simple dashboarding where I may display the following in separate areas of a dashboard; Total Number of X Total Number of Y Total Number of Z I want the ability to just display 1 cell of data per widget, that refers to a specific cell in a sheet, but instead I seem to be pulling in the…
