-
Rich Formatting On "Summary Sheet"
I'm stuck! I am effectively trying to create a Sheet Summary report with conditional formatting, however, I understand that is not an available feature. Instead, I am trying to create a sheet (not a report) with formulas that pull from multiple sheets and can be formatted. I have 20-30 real estate development/construction…
-
Need Help Sorting & Grouping "Day" Data By "Week"
I'm brand new to functions and Smartsheets in general so please bear with me as I attempt to learn with you all. I've read over the functions documentation and to be honest, it's a little over my head. I'm trying to suss out a step by step otherwise I get lost. But I'm hoping I'll get there eventually! Here's the nuts of…
-
2 Reports not showing on my published dashboard
When I publish my dashboard 2 reports are stating they need to be viewed on Smartsheets. the other 3 reports have viewed no problem. They all have the same permissions levels. HTTP s://app.smartsheet.com/b/publish?EQBCT=3c11a22bbcc142df8368f9ac975c1ec4
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…
-
Adding a report to a dashboard with a "Calendar" view vs "Grid" view
Hi - I'm trying to add a "Team Vacation Planner" to a Dashboard with a "Calendar" view vs a "Grid" view. No matter what I do, I still get the report in the "Grid" view. Any ideas?? Thanks in advance.
-
How to Alter the "Sheet - IT Ticket Metrics"
I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt to specify to a single customer looks like this =COUNTIFS({Created Date Range},…
-
Column isn't an option to filter by
fairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a filter with 4 conditions but only 3 of the 4 columns are options.
-
Can I lock the view of a report in Calendar view?
I have a report that is saved in calendar view and a link is placed on a dashboard. When I open the report either directly or via the dashboard link it opens in calendar view. However when shared collaborators open the report it opens in grid view.
-
Automate sending out a PDF based on meeting criteria
I'd like to automate the generation of a PDF of a sheet or report based on criteria defined in an Automate Workflow. This doesn't appear possible. For example, send out a PDF when a cell containing a date changes, or a completion percentage is modified, a comment is made, an attachment attached, etc.. I'm well-versed in…
-
Calendar View on a Report won't allow us to make comments
Hi, we have a Delivery Report which takes info in from approx. 50 Project Delivery sheets. If looking at the Report in Grid View we are able to add comments to all rows/sheets but when we are looking at it in Calendar View we aren't able to add comments to the vast majority of rows/sheets. There seems to be one sheet which…