-
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?…
-
Is the report made from a sheet suppose to change as the sheet changes? Issue
Hi, In my sheet I have 137 rows, but in the report I made from the sheet I have 167 rows. Shouldn't both the sheet and the report have the 137 rows? Thank you
-
User Access Review and Approval
Hello, I am trying to create a workflow for role owners to review and approve their user access. Role Owners have multiple users- so I don't want to have an email go out for each user. Has anyone created a report like this?
