Conditional Linking?



I was wondering if there was a way to unLink cells if a condition is met, i.e.

if Column1 is checked then UnLink all cells in all rows

this would be to lock values coming in once checked

or if that is NOT possible ...

If a value that comes into a linked cell (from another sheet source) is say $10 and I set up an automaton to copy that value to another row in the same sheet would the linking (in the original cell/row) copy too or just the $10 value at the time the automation runs?

Thank you in advance for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!