Creating Automation to update a referenced cell between cross referenced sheets

Terrhan

I am looking to create an automation that would run on the 1st of every month. I have a rent schedules calculated and I need cells updated from the rent schedules sheet to the master client sheet.

Take these cells from smartsheet #1 (Cost Schedule)

And update to smartsheet #2 (Client Overview).

Do I need to create a cell in Smartsheet #1 for =Today() to trigger the automation, and then how do I update the conditions and actions to move the information from smartsheet #1 to corresponding smartsheet #2?

Paul Newcome

Why are you wanting to use an automation monthly as opposed to using formulas with cross sheet references such as a VLOOKUP or an INDEX/MATCH?