Best Of
Re: Child Row Formula to Reference Parent Row
Thanks!
OK, so this should be easy to do by adding that helper column. You can name it something like [Level] with the following column formula:
=COUNT(ANCESTORS()) + 1
Then, use this as your column formula in the Parent Name column:
=IF(Level@row = 1, "", IF(Level@row = 2, [Task Name]@row, PARENT()))
Which will leave the cell blank if it's at that top level, it will return the Task Name if it's the next level down, and then any children of that will inherit the parent value.
Technically, you could embed the level piece within the formula but I think you'll find additional utility with a separate Level column (i.e., conditional formatting!)
Sarah Keortge
Re: Has anyone else had issues with the new Contact Support chat box?
hi @Cassie L,
I am 100% you shall open a Support Ticket as it's not normal behaviour.
here you can open the ticket so they will fix support place for opening tickets :)
hope it helps somehow.
kowal
Re: I want to check a box if the outage was identified on a workday between 8:00-16:00
Hey @Amy A
Try this
=IF(AND(AND([Day of Week]@row > 1, [Day of Week]@row < 7), AND(TIME(Time@row, 1) >= TIME(8, 0, 0), TIME(Time@row, 1) <= TIME(16, 0, 0))), 1)
Will this work for you?
Kelly
Kelly Moore
Re: Formula for 24hour clock overlap - booking clashes at the same time on the same day
Hi @Sam Swain
To find the true booking overlaps, you can use a helper column with a formula that checks for the same date, bay, and overlapping times. I would try the below formula
=IF(AND([Date Of Parking]@row = [Date Of Parking]1, [Bay Number]@row = [Bay Number]1, OR([Start Time]@row < [End Time]1, [End Time]@row > [Start Time]1)), "Clash", "No Clash")
ChristianFinke
Re: Automatically generate parent row with child rows via form?
Hi @toribear
There currently isn't a way in Smartsheet to auto-generate Hierarchy (parent/child relationships) or to auto-generate a set list of rows after an initial row submission. Please provide your feedback to our Product team through this form, here!
I would personally have a reference sheet that houses all the Parent/Child combinations or the possible checklists that would be needed based on each submission. Then you could use a Copy Row Workflow to initially copy the Submission to Sheet B, and then manually copy/paste the correct grouping of Children from your reference sheet beneath this Parent row.
Cheers,
Genevieve
Genevieve P.
Re: Automation to allow Cell Change for Checkbox "Flag" or "Star"
After refreshing dozens of times and running through the list of cells over and over, I found my way to this post. I can't believe it!
I changed my column to the "checkbox" style, updated my automation, changed the "checkbox" style back to the flag, and then it disabled the entire workflow. But it is a checkbox column....?
It's been over a year now. Is there any sign of this getting updated?
I want rows to automatically be "flagged" based on certain conditions. A checkbox implies that something is "good to go" or "complete". The flag style will show that something needs to be reviewed -- "attention required". I don't want people to manually skim the sheet for the conditions that require attention.
sheetsmartsarah
Re: Can i move child rows to another sheet and copy the parent row across too?
Hi Ward,
Thanks for clarifying. How would i add an automation to insert new rows for the quarter ahead, under each parent row and with all month names included? Is that possible?
Thanks.
Luka
Re: Can i move child rows to another sheet and copy the parent row across too?
Hi @Luka
There currently isn't an automation or form that can create hierarchy, or would know under what parent to insert the new rows - please feel free to add your vote to this related Product Idea: Indent child records based on formula or automation
What I would suggest here is to list out the next few years, all in the same sheet, using a Date column to identify the first of each month. This will then allow you to set a filter on the sheet so you only see the relevant rows, like so:
You can have the default for opening the sheet show you the filtered view.
While you could use a Move Row workflow if you want to get rid of child rows past a certain date, I agree with @Ward.Hively and would suggest keeping it all in the same sheet.
Cheers,
Genevieve
Genevieve P.
Re: Can a proof be accessed via a published report?
@Kristen Christman Hi - In case you don’t find SOR get an answer I will share what I usually do to satisfy my curiosity.
I tend to reach out to people internal/external to the team/organization I’ve built working relationships with, explain the why and what, then I ask them if they have some time to assist with executing a couple of quick test cases. Hope this serves as an option. 🙂
This is an older post but may serve as a point of reference for you as well: https://community.smartsheet.com/discussion/77255/are-proofs-available-via-published-link
Yvonne Smythe
Re: Can you filter a Dashboard?
Live multi level Filtering in Smartsheet is something lots of our clients have been asking us for, so using the Smartsheet API we have created just that solution. A 14 day free trial is available and the cost starts at $125 a month. Sorry we have to charge for this, but it took months to build it so it is self configurable by the user.
More info here https://smarterbusinessprocesses.com/smarter-dashboards-3/
Hope that helps?
Richard Rymill
CEO SBP
