-
Can we please include widget for including iframe ?
Smartsheet community, I have tried smartsheet labs for the charts and have a live iframe to be embedded in the Dashboard but there is a no widget to include iframes. can we include this and do we have better options for charts and dashboards in smartsheets as i feel still a long way to go for better dashboards in…
-
Cell linking report sheet linking
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new workspace or folder for each project. I am hoping there is a way to make the project/sheet links stay within the…
-
Very Large Save Causes Formula Corruption
I've been trying to understand a problem I'm having with two of my largest Smartsheets. If I move a row up or down or insert or delete a row, especially near the top of the sheet, the Save process will apparently corrupt formulas here and there in my sheet with no warning or error message given. I've gone back and forth…
-
Portfolio Reporting
I am new to Smartsheet and my goal is to have a dashboard for our PMO with links to the various projects. Each project may be led by different people in the company. Do you have suggestions on how to set up the Dashboard for automatic roll up of information? I have found some helpful articles here, but I would love to know…
-
Unable to Export to PDF
I've seen that others are starting to report a similar issue on the community board. I was unable to export PDF's following the last upgrade of the system, and the same issue is back today. This has a real impact on the way I use Smartsheet, and is becoming a tytpical frustration. Smartsheet, can you comment on why this…
-
Finding the latest date of certain tasks based of those tasks' attributes
Hello, I'm looking to find the latest end date for certain tasks based off of attributes in those tasks' rows. For example: If I want to find the latest date of tasks in cycle 1 of a release (but not cycle 2), and within that there are 5 different categories of tasks but I only want to know the latest end date of one of…
-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
-
Enhancement Request: Formatting for Reports
There are numerous posts on improving formatting on Reports. Here is a specific use case: I have a sheet with multiple date columns and tasks. On one report, I am showing (either Gantt or Calendar) view of the tasks color coded by task. In a second report, I would like to show the dates (either Gantt or Calendar) view with…
-
Creating a Task Tracker for Multiple Leaders
I manage a large group of leaders and locations who all are completing similar tasks throughout the month and I am looking to track progress without going back and forth via email. I have created a task list for each location as the parent and each specific task as sub-tasks and then assigned them to each leader. When I…
