Creating Automation to update a referenced cell between cross referenced sheets
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?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 376 Global Discussions
- 205 Industry Talk
- 437 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives
