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
Best Answer
-
You would have to do this manually.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You would have to do this manually.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi @OrenW
I hope you're well and safe!
Unfortunately, it's not possible now to copy automatically copy values between cells, but it's an excellent idea!
Here's a possible workaround or workarounds
- Please have a look at my post below with a method I developed.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi Andree ,
Thanks for your suggestion but I feel it is a complicated work around .
The way I am currently dealing with it is manually coping the "Due date" of an important mile stone to a column "Track MS" and then have a visual flag column indicate if the date has passed (red) and I created automation to alert the relevant stake holder.
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@OrenW Did you figure out how to do this? I am needing to do the same thing but can't figure it out.
-
Sorry , The only way I found was doing it through a second sheet as a temporary data holder .
I did not want to do it this way (too complicated to maintain) .
I decided to do it manually for now .
-
another way that is less than ideal, but works is at the cell you want the data copied to
= [Nameofcellyouwantcopied]@row
and then drag the formula down as far as you want, or might want it to go. You don't want to do a column formula because then you can't write over it if needed (an enhancement is needed there too).
-
Hi @OrenW
If I got the correct understanding of what were you looking for, I think I have a solution. You can use (IF) to test if the check box is checked, if yes then the next column will show the same than the previews column. Follow the formula.
=IF([Column2]@row = 1, [Column3]@row, "")
Column2 is the Checkbox Column, If = 1 (checked)
Column3 is the column that has the date
The formula is placed in the Column4, if checked, equal to column3, if not, ""( blank)
Anytime you change the date in the cell of Column3, automatically, column4 will show that.
This formula serves for any type of data, you only need to define the same type for both columns.
I hope I could help.
Happy holidays.
Sergio Matocanovic
-
Hi Matocanovic,
Thanks for your reply .
This is not exactly what I wanted to do as it will continually keep col 4 the vaue of col 3 as long as the checkbox is "on" .
The goal of my request was to check a box called "Copy this due Date to be tracked" thus creating a "baseline" of a date I will track for changes (ie - if column 3 will change in the future - I can get an automated alert) .
I am assuming this needs to be done via automation but could not find a way to do it .
I currently just manually copy the date for important tasks I want to get notified for .
BR
Oren
-
@OrenW now I could understand what you need.
I'll try to find a way to do that, If I find something that really help you I'll reply you back here.
Talk to you later.
Have an amazing 2023.
Sergio Matocanovic.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!