Copy row with a new date in cell

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!