Copying dates to another sheet
Hello Community. Today I'm looking for a solution to copy dates from one sheet to another sheet if they will occur within the next 30 days. I didn't want to use the Copy row Automation because it copies all the columns from sheet to the other and I can't select which fields I would like to transfer.
What I have is a project schedule on one sheet that lists all the start and finish dates along with financial data then I have a running action list on another list. When one of the phases from the 'Project Schedule' sheet has a finish date that is coming up, then I want the date and the project name to be copied to my 'Action List' so that I can have an action item that will cue me to schedule a meeting.
Not sure which work around will best fit this scenario. A formula? A report? Some type of cell linking?
Answers
-
I would suggest a Report for this. You could have the report emailed to you on a recurring basis.
Or you could set up an automation that runs every morning to send you an email containing all of the rows that meet your criteria and you can select which columns are shown in the Automation.
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!
-
To add to Paul’s excellent suggestion.
Another possible workaround could be setting up a solution with VLOOKUP or an INDEX/MATCH combination.
What do you think?
Would that work/help?
Be safe and have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives