-
Formula to Average Child Progress Bars
I'm hoping to find a formula I can use to automatically fill out the parent row's progress bar based on the child rows. The result would look something like this, just not sure if this is possible. * * Section 1 is 50% because: Sub-task 1 + Sub-task 2 + Subtask 3 = 150 then / 3 tasks = 50% progress bar Section 2 is 75%…
-
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
-
Count Parent cells
What is the formula to count the number of parent cells not including "children"?
-
Count unique
Each month I run a report for training attendees. I have sorted by month and have the count of attendees per month then year. I created a filter for each course that will provide the number of attendees for that course. I need to create a formula that will count each unique attendee for the year and then list all of the…
-
Is there a way to publish a sheet with the side toolbar collapsed?
Is there a way to publish a sheet with the side toolbar collapsed or eliminate it, and still have edit mode to add attachments, comments, and select dates?
-
Count number of rows
I have a sheet that has a status column which is a dropdown list - In progress, not started and complete. I want to return the number of rows where status is not complete. How do I do this?
-
SUMIF Circular Reference
I have a time/hours sheet to keep track of customers that have varying statuses. The statuses include in progress, complete, and cancelled. I currently have the sheet being sorted based on the status so that It has a title row showing the total numbers for each status below it. As a status changes from in progress to…
-
How to get EOM (end of month)?
How do I get the EOM (end of month) if my start date is 10/07/2016 ? I'm new and having some trouble with this. Thanks.
-
How do you create a "days remaining until start date" column that will select the start date one eac
Hello! I'm new to Smarsheet and haven't been able to figure this one out. I have a sheet with many tasks that have different start and end dates. I want to create a column that will tell me how many days are left until the start date of each task. This formula works: =[Start Date]23 - TODAY() But I need it to automatically…
-
Auto-populate %complete based on dates / duration
Hi, All my project sheets are all set up with project, status, start date, end date, duration, %complete and predecessors. I also have a checkbox column to mark when a task is complete. I'd like to format my % complete column so that it auto-calculates how much of a task has been done based on the start and end dates. I'd…
