-
Smartsheet PDF Exports Break Links Over One Line?
I am having an odd issue in using Smartsheet and exporting Reports for the first time. I created a report from one of my sheets, with one column that includes a hyperlink. It's a pretty long link, but the text is wrapped so it simply splits the link up with a line break in the export. However, the actual HYPERLINK that it…
-
Combining SUM and RIGHT
Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative's score to their managers. I am getting #UNPARSEABLE as the result. Can someone help correct me? A1, Customer…
-
How to Avoid Having to Select Each Sheet for Report Inclusion
Has anyone found a way to provide Smartsheet a list of sheet names to include in a report or a filter based on Sheet Name that can be used to include / export from Reporting? It is extremely tedious to manually select each individual sheet to include in a report when you have 100+ projects from which to select from. Thanks.
-
Dashboard Chart shows "No Data to Display" for 0 values
Hello, I have looked at a couple other questions about this already but I cant seem to understand how to fix my specific situation using those answers. I have a Column chart with an X and Y axis on a Dashboard. The chart itself is being filled by a Report filtering the last 30 days. The "Created" and "Score" columns are…
-
How do I generate the same information that is entered in the parent, into the children?
I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is the deciding status, the status that matters. I want to show all projects that have a certain PM assigned, AND if the…
-
IF Formula Question
Hi there, I am kind of new to SS formulas and I am trying to create a function that adds an amount to a column IF that column is a certain deal type. The columns that I need the addition to are labeled "Development WAG $" and "Implementation Costs $". IF the "Deal Type" column has "Lease/ Purchase" I need the $350,000 to…
-
Sheet Summary Formula versus Sheet/Report Filtering
Hi all, I've been scratching my head on this for a while and I can't resolve why the filtering I do on a sheet/report is not matching my formula on a sheet (upon which the report is based on). Here it goes: I have an intake sheet for my projects that when a PM creates a project via Control Centre, it spits out the expected…
-
Show Reports' sheet sources for Workspace Sharing Report
In Workspace folder, when you right click, you can download workspace sharing report. With this, you can view list of dashboards, grids, and reports in the workspace. Would it be possible to get information about which grids were used in a reports?
-
Can I create a report with mutiple filters for a dashboard?
I created a dashboard that display the issue, report date, number of weeks and wireless chipset, I would like to have a filter per month. In other words, I want the capability to add 12 filters (1 per month) and apply the filter once the month is done to show all activity at the dashboard, is that possible or I need to…
-
How can I create a quarterly dashboard?
Currently I have an annual dashboard created by mostly pulling multiple reports that primarily uses sheet summary data. How can I pull quarterly reports using the dates 10/1/22-1/31/23 to filter my reports? Keeping in mind that I can't filter by columns because I am using sheet summary to build my reports. Here are…
