Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me.
My question is, is there an automation or a formula where when it is moved back to my main sheet that the date on Next Recurring Date, will now show up on date column, or will that be a manual update.
Best Answer
-
Hi @Genesia
How about adding a Clear Cell Workflow to your second sheet when a row is added?
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Answers
-
I would suggest a helper column on the second sheet with a formula that checks a box when the move row automation is supposed to trigger. I would set up the move row automation to trigger off of this checkbox to ensure it is in fact checked before the row is moved.
From there you can set up a record a date automation on the working sheet to populate the date when a row is added and that helper box is checked.
-
ok, @Paul Newcome, thank you, but I get what you are saying, but I think I am missing something. I have a helper column that is checked when a date has been reached, and when that date is reached it is moved to the 2nd sheet that I called archive. When it is moved to that 2nd sheet that will populate my next recurring date and then move it back to the 1st sheet which is fine, but do I need another helper column on the 2nd sheet to say when the next recurring date has been generated to now unchecked? That's where I'm stuck?
so as you can see the checkmark is checked because of my first sheet, so now that i have a recurring date it knows to move it back to the original sheet, but i want the checkbox to be unchecked when it is now on the 2nd sheet. I thought that i couldn't have a formula on the completed column because it is one on the main sheet.
I hope i am making sense.
-
Hi @Genesia
How about adding a Clear Cell Workflow to your second sheet when a row is added?
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.9K Get Help
- 441 Global Discussions
- 153 Industry Talk
- 500 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 78 Community Job Board
- 511 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- Hello! Long time listener, first time caller — We have a weekly update dashboard that is presented on Thursdays. We'd like to have the date displayed be either the previous weeks Thursday or the curre…
- Can a JOIN function be used in a Sheet Summary to join two or more Sheet Summary Fields? I have two separate columns that I use a JOIN function for, but I'm not seeing how I can use it in Sheet Summar…
How do I use predecessors to ensure a portion of rows are complete before being able to go to the ne
I am wanting to use this format for pre-con to ensure nothing is missed or overlooked. I want to mitigate mistakes from our project managers to prevent project issues by not allowing them to move to t…