How to Record Data Weekly
Hi,
I now have 1 main sheet, and then 4 different sheets where it moves over data to, 4 times throughout the month, using automation to move certain rows by month on the I.e. 7th etc. then I have a dashboard showing the different data of the 4 sheets, so you see 4 times throughout the month how the numbers changed.
Is there any way to record the data weekly?
so I'll have last week Friday, 2 weeks 3 weeks and 4 weeks ago Friday,
Thank you! 😀
Answers
-
Hi @A Rose
Hope you are fine, did you mean you want the date stamp for each row to be weekly?
Or you want the data that move between your 4 sheets to that sequence weekly instead of monthly?
Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.
or you can call me to discuss this in details:
My Email: Bassam.k@mobilproject.it
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Hi @A Rose
I hope you're well and safe!
Yes, you can set up a Workflow to copy the rows weekly on a specific day instead.
Would that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
-
Hi @Andrée Starå & @Bassam Khalil ,
My issue is that if it copies every week from "Sheet A" to "Sheet B", then i won't know on "Sheet B" what is from this week and what is from 2 weeks ago,
the way it's now is that it copies from sheet a to sheet b on the 1st, then it copies from sheet a to "Sheet C" on the 7th, etc. etc.
But if it copies every week to a different sheet, how would i know what data is from 2 weeks ago?
because it's copying every week not every second week..
Thank you!
-
You can add a system column "created date" it will register the date that column been copied to sheet then you can create a helper column with formula to analyze the created date of the row and define the week
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Happy to help!
You could also add a so-called helper column to the main sheet that registers which week/month it is in separate columns if that would help?
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!