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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives