-
Print table into template
I'm looking for a way where I can export a table from Smartsheet into a pre-set titleblock. If there's a way where I can print directly from Smartsheet and have the titleblock set up so it prints with the table, instead of just the logo and title that it's currently offered in the printing window.
-
Help Needed
Hello, All. I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula to sum up 2 other values in the column if they appear (column value equals that…
-
Milestone diamond to be displayed within Parent Timeline in the Gantt View
Background: I have a Project plan where I have my project/features out team is working on. There are two milestone task under every feature: Feature#123 Task#1 Task#2 SIT(Configured as milestone with duration 0 and startdate) QA(Configured as milestone with duration 0 and startdate) Prod(Configured as milestone with…
-
Dashboard/Report link issue
Hi everyone, A person on my team has created a dashboard with a report widget that has a link at the bottom on it. The report itself has over 700 line items, which is over the 150 max per this article: https://help.smartsheet.com/articles/2482269-using-report-widgets We would like to remove the link. Alternatively, how do…
-
Filtering report
I am trying to filter a report that uses a second sheet that has a list of customers and their salesman. The list sheet is just two column as shown in the picture above. Contractor name and the salesman assigned to their account. The sheet I am trying to filter, has all the contractors on a job listed in a single column.…
-
Custom colours in grids
Hello. I love that custom colours can be selected by choosing the hex code or RGB values. This is especially great for the dashboard views with the graphs, titles, etc. One problem though is that we do not have the same option in grids. There the standard colours are the only options. Is it possible to add this to grids,…
-
Report pulling in blank rows
I've built a report that is showing information in some rows and not in others. The data exists and, while it is pulling from multiple sheets, the information missing isn't from one sheet in particular. Previous posts, circa 2016, indicate possible server lag. Other recommendations on a fix?
-
Some cells not populating with column formula
Hello all, I've got a column formula that automatically determines start date based on a different date. It appears though that some cells are not populating (see snapshot) and I wondered if anyone can advise why it might be? The Start-Up duration column has a column formula "=3" for 3 months and Start-Up start date should…
-
Looking to count the number of Stars
Hello all, I'm looking to count the number of "stars" within a column and have been testing with =COUNTIF(check_column, "true"). This isn't working. Any ideas?
-
Dashboard chart - default disable lines
Hi, I currently have a chart in a dashboard which displays 15+ items as lines. It is great that I can enable/disable each item individually but is there a way to have them disabled by default when you open the dashboard instead of just showing them all then then going one-by-one to disable them (and showing just a couple…
