I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
Using Smartsheet28Dan Snodgrass
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows:
We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions42Melissa P-B
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet40Mary Vogt
I am working on creating a report in which data is obtained using a Smartsheet form.
For each new answer on the form…
Using Smartsheet20Jefferson Ribeiro
I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet.
The Pivot Table is set up where each r…
Premium Apps and Integrations22KellyAnne Brophy
I have several 13 Smartsheets that make up a campaign of projects. At the top of each sheet I have some metrics, including the % complete for all the projects, combined, on the Smartsheet.
I want to create a new Smartsheet that links dat…
Formulas and Functions8Donna T
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
Formulas and Functions23Daniel Child
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions274UnaB
I have created 2 sheets:
Both the above sheets have one common field: Employee ID.
Now I want to create a report by referencing to this common data field (e.g., Employee ID) and "blend" the…
Using Smartsheet19[email protected]
I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form.
I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
Formulas and Functions14Amy Arnold
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
I can't find a way to accomplish certain kind of chart using chart widget in dashboard. Chart is supposed to show multiple lines, one for each team member connecting dates when a certain task was completed. Tasks are re…
Using Smartsheet224Jakub Gill
I am attempting to consolidate multiple business worksheets, for an aggregate pie chart health status on a dashboard for executive management. See word doc for details
Each project sheet has basically an identical structure and each line item is assigned to a specific person/user (Contact list). There are approximately 300 lines per project sheet.
Each user has a report that shows only the tasks assigned…
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
I'm finding that conditional formatting is not consistently updating in reports, and my staff are complaining about it. See for example below, the "Rollinson Downstairs..." task highlighted has no conditional formatting even thou…
Using Smartsheet38Doug M
We have three basic templates we may use to create a new WorkSpace. Each new WorkSpace represents a project and will have a sheet called "Transition Tracker". I'd like to run a report of information from each sheet in each Work…
Using Smartsheet18Christina Reid
I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION.
Here's my Master Smartsheet.
This is the formula I started using based on responses in the c…
Formulas and Functions25Amy Arnold
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project.
Most of the reports and dashboards I've tried to crea…
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available.
Data coming in: Building | Unit Number | Rent Ready …
Formulas and Functions24Xander Brennan
Can someone provide me a workaround here.
I would like to run a report that lists all the tasks due to start in the next 5 days.
But what I need is to include the Phase name, even though the Phase has already started.
I have added …
Using Smartsheet18Andre Drinkwater
On the first day of each month, I send a report listing all documents published in the previous month. The report includes hyperlinks to each document's location.
Before the recent Smartsheet changes to reports, I would email the re…
Using Smartsheet53Ginger Mason
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions16Mike Wilday
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
I would like to update the 'Status' Column to CLOSED when the 'Done' checkbox is CHECKED.
Formulas and Functions73Ashanth Suntharalingam
I am trying to create an aggregated view of data from multiple sheets using the "Sheet Summary Report" but when get to the Builder, it only shows the system columns for display. Obviously this is not helpful if I cannot merge tog…
I did not see this topic covered:
Is there a way to combine logical "AND" and "OR" when creating a filter?
The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR)
Here is w…
Im really struggling with getting an absolute cell value to stay in a sheet or in a sheet summary.
maybe im going at in the wrong direction. please help.
I have a form on my call centre data sheet that is adding an information line each d…
Formulas and Functions33WOODY
i have a repotr based on sheet with ~1500 rows (parents and children).
as i know there is no way to show the parent and children in repost so that i mark in color the parent and sort the report to show the parent and children.
but, now i w…
Using Smartsheet34Netanel yosef
I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.
Here is my formula that calculate 0 every time (at least not an error) :
Formulas and Functions22Assaf Elad