Automation triggered copy one cell to another on same sheet

Hi ,

I would like to be able to "check" a box in col A which will trigger a copy of the content in col B to Col C (but not change value as long as the checkbox is checked)

I want to use this to flag a specific line/task as one which is due data is important for me so I want to copy it to a column "important dates" but the copy should only happen when I check the box (if original data changes the content in the destination should not change)

Ex:

A B C

O 1/1/22

If I check Col A I want the date from B to be copied to C

A B C

X 1/1/22 1/1/22

If now someone changes col B it will no be "mirrored" to col C

X 5/1/22 1/1/22


I assume it is needed to be in an automation flow but cant find how to do it .


Thanks

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!