-
Bringing in rows from multiple sheets in a report
Hi, How can I bring in specific rows from multiple sheets in a report? Thanks.
-
Filter by Hierarchy
I have a Smartsheet organised by hierarchy, I want users to be able to enter data but only to be able to see their own group (represented as top level hierarchy), my understanding is the correct way to do this is to create a report. But how can I filter the report so it shows a named top level hierarchy and all the…
-
Can you append sheets in Smartsheet like you can power query in excel/power bi
Hi I want to append/consolidate sheets in smartsheet in a master file or separate sheet all the sheets are the same but for different locations im using forms to collate the info because the forms are site specific I want to combine the two sheets below as example in a master sheet and at the same time the master will…
-
Automatic Finish date and Finish time columns for a 3D Printer Sheet
Hello everyone, I am creating a sheet for my 3D Printer and I need some help as I am new in Smartsheet and in using functions. I want to make the "Finish Date" and "Finish Time" automatic, meaning once I input the Start date, start time and duration, the Finish date and finish time will automatically show when my 3d print…
-
Progress % in dashboard
I want to add a widget in my smartsheet that shows how close we are to hitting our target based on a summary total. For example, our target is 200 and the sum total from another sheet shows 100. I want a to show that we are 50% of our goal. Any Idea how I would do this?
-
Report based on all "like named" sheets in a Workspace
I am using SmartSheet to manage our projects in a "Projects" workspace. Each project has its own folder with a few sheets. All the sheets are named the same one of which is "Project Plan" each Project Plan has an "Assigned To Person" column. New project gets a folder in this Projects Workspace with all the same sheets. I'm…
-
How do I make a Smartsheet that keeps track of initials
I'm trying to make a Smartsheet that keeps track of how many times a set of initials appear on a column. I have a Smartsheet now that people can put there initials on when they complete a task but I would like to be able to track how many times people completed certain tasks.
-
Find
Hello everyone, I'm afraid this is a very basic question: How do I find the start/end date (or generally any other value from a row) of the main task in my sheet? By "main task" I mean the tasks that governs all others tasks, where ANCESTORS would equal zero, but that's not neccessarily in row 1. So far I have tried to use…
-
Automated Reporting
In our organisation we prepare a number of different reports to different levels within the organisation. A lot of this information can be duplicated across different groups and levels. I am wondering whether we could create a sheet to capture these reporting updates from teams, through direct entry into the sheet, or…
-
#DIVIDE BY ZERO
Hi, I have a Smartsheet with calculated columns like - =SUM(Open@row / SUM(Open@row:[Past Due]@row)) The Smartsheet is being used to create Donut graphs on a Project Dashboard. In the example above; Open = 0 In Progress = 0 Closed = 0 Past Due = 0 rather tan getting 0%for Open, I get #DIVIDE BY ZERO How do I resolve this?…
