-
Seeking an Alternative to the Absolute Reference of a Parent Cell
Has anyone used a formula which can report a child's percentage of the total rolled-up in its parent without using absolute cell references? I'd like to avoid absolute references because I'd like the formula to be consistent all the way down many parent cells, which will have different absolute references to be used in the…
-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
-
Dates Don't Act As Dates if Linked from Another Smartsheet
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is linked from another Smartsheet. I want to add 180 days to the [Opening Date]1. [Opening Date]1 = 08/22/82 Here's what the…
-
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…
