-
Reports that pull only parent rows
Is there is a way to do this without having to create another column and naming it Parent?
-
Horizontal Reporting (Transpose)
Hi! I'm currently having some issues generating a report from smartsheets that enables be to do some additional reporting away from the product to enable external sharing (due to data, and legal reasons). I'm looking at building a milestone report however the current report that is being generated in smartsheets is more of…
-
Schedule an export of a Report
I'm trying to link up a SmartSheet report to our Company wide reporting dashboard in Power BI. To do this I'm looking to schedule an export of a report (say weekly) to save in SharePoint where it is accessed by Power BI. Has anyone else tried this? Is there any way to do this? Thanks! Donna
-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
-
CEO interruptions causes delays
My CEO continually interjects his own agenda into the company's workflow. It's been a challenge for many years, and we all know that he won't change. So knowing that we, as a company, cannot tell him to stop, I would like to create some visual that will show how his interruptions cause delays in deliverables of other…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
-
conditional formatting between 2 columns, same row
is there an ability to set a conditional format based on two columns in the same row: completed (column) date is later than the due (column) date – the cell turns red completed date entered is before (or after) today's date
-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?
-
Locking view when sharing
Hello, I have used Smartsheet for some time now, but just started investigating using Card view. Unfortunately, Card view cannot be used on a report. Previously I had a report that combined my personal tasks as a manager from one sheet with tasks from my involvement in projects my employees are working on to create my…
