1

Hi All 

I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically?

In other words, some kind of inheritance mechanism. 

Thanks in advance!

2

Hi SS Community! 

 

Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me. 

Currently, I have this: 

=IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On

1

Greetings,


In a Contact Column, and in a ancestor/child relationship, I would like for parent rows to summarize/list all persons in the child tasks.  Is Smartsheet able to perform this action?


E.g.


If the child records list:

  • John D
  • Claire H
  • Emily G



I want the parent to show:

  • John D, Claire H, Emily

7

Hi,

We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete"

What is the formula that I can use in a flag column to say - Flag any with an Order date 6 WEEKS OR GREATER, and Status NOT EQUAL to Complete? 

Thank you so much in