Copy row with a new date in cell

Mike Broglio

I have 2 sheets set up, a source sheet and a destination sheet. Every morning I need the source sheet to copy over a row to the destination sheet with a date based on a formula, today()+1. The problem I am running into is that unless I open the source sheet everyday to trigger the formula the date copied over has the old date value. The formula is not being refreshed. Is there a way to copy the row over with the updated date value.

Andrée Starå

Hi @Mike Broglio

I hope you're well and safe!

Please have a look at my post below with a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

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!

Mike Broglio

Thanks. That did the trick. Just to document the complete solution the date helper column and the date column with the formula are on the same source sheet. Both are copied over to the destination sheet

Andrée Starå

@Mike Broglio

Excellent!

Happy to help!

✅Remember! 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!