-
Return 1st column value if 2nd and 3rd column is blank
Hello, I am trying to come up with a solution for my smartsheet involving 4 columns (4th being the result column). I wanted to return the value from the 1st column whenever 2nd and 3rd column are blank, if not return the value from either 2nd or 3rd column. These columns contains dates by the way. Sent (1st) ; Won (2nd) ;…
-
Changes Report
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects whose end dates that have changed in the last week.
-
Report Builder Problems
With the recent (Sept 19, 2019) update, non-licensed users no longer have the ability to update their Report Builder within SmartSheet. This poses a significant problem for my company, as we have multiple licensed users and ~100 (non-licensed) individuals who execute the tasks assigned. Am I correct in thinking that each…
-
Editing Chart Widget
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
-
Pull child rows into report based on parent rows
Hello, would much appreciate it if anyone is able to help me out. I would like to be able to pull both parent and child rows of a sheet into a report based on a criteria which only exists in the parent row, is this possible? I'm not sure if there's just a setting I missed. Thanks, Sean
-
For project status and risk dashboards - what are your favorite ways to use SmartSheet with Excel?
Hi all, I've reviewed some of the threads on the community here about limitations with Smartsheet not being able to export Harvey Balls or other images into Excel. These icons are extremely useful for risk dashboards and the like. When we registered for SmartSheet, I was hoping to be able to export these things, but it…
-
How do you change or delete a recurring email on a Report?
I set up a report to be emailed automatically each week and the PDF puts the overflow onto separate pages, so I would like to change (to Excel) or delete that recurring email. I can't find where to do that.
-
Gantt Print Problem - Can't choose columns to print
Anybody having problems with their "non-licensed" users not being able to select the columns to print in a Gantt view? The "edit" button for selecting columns to print no longer works. I'm wondering if the recent software update has broken this functionality.. We receive an error that says "An error has occurred in the…
-
Report Uncompleted Tasks when Date is not Used as a Reference
Greetings! New (very green) customer working through a ton of issues and plans before go-live on Jan 1. We are using SmartSheet for simple workflow processes that contain multiple tasks with some dependencies and involving several different departments. We do not create deadlines based on dates, rather, when a particular…
-
Automatically move item to different Smartsheet once completed?
I have a feeling that this solution doesn't exist within the current setup. Is it possible to move a row from one Smartsheet to another once the item is shown as completed? Thank you!
