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?
Answers
-
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?
