Get the Template here 👉 www.garethpronovost.com/template-meal-planning-opt-in 👈 Learn about Automation on this webinar 👉www.garethpronovost.com/webinar-registration 👈
@@GarethPronovost Quick question: I would like to plan for meals for the next two weeks instead of just the upcoming week, but am unsure where to adjust the formula for that. How can I do that?
@@Andrewmichealsmith the formula to adjust is in the Calendar table. You'll want to update the CURRENT WEEK field. In your case you'll need to update the formula to bring in the current week AND the next week as well. So instead of matching week = 44, you'll want to match week = 44 AND week = 45. For example: IF(OR(WEEKNUM(TODAY())+1={Week Grouping},WEEKNUM(TODAY())+2={Week Grouping}),'Current')
Hi! I am loving this and input most all of my recipes this week. However, I am having trouble with the "Current Week" not auto populating my "Current Ingredients". It seems that only Saturday, Sunday, and Monday are appearing in the current ingredients. The rest of the week, Tues-Fri, are not there. Have you ever had an issue with this? Would appreciate any thoughts!
Great system you have going here! I was thinking of building something similar. If I was going to add anything to this, I would add a way to sort each recipe by complexity or how long each one takes to prep. There are times where I don't have a lot of time for prepping so I want to add in a meal that doesn't take long to prep on those certain days. Another sorting feature would include the cost per meal. It would be a good way to sprinkle those in my plan so that I'm not spending so much on groceries.
Get the Template here 👉 www.garethpronovost.com/template-meal-planning-opt-in 👈
Learn about Automation on this webinar 👉www.garethpronovost.com/webinar-registration 👈
Thanks for sharing Gareth
Thanks Gareth . I Was looking for something similar for wood construction and ordering. I will adapt this.
Cant get template. I can only register email
This is brilliant. I've been looking for something to plan meals for my large family. Thanks for making this so cool..
Awesome, happy to help!
@@GarethPronovost Quick question: I would like to plan for meals for the next two weeks instead of just the upcoming week, but am unsure where to adjust the formula for that. How can I do that?
@@Andrewmichealsmith the formula to adjust is in the Calendar table. You'll want to update the CURRENT WEEK field. In your case you'll need to update the formula to bring in the current week AND the next week as well. So instead of matching week = 44, you'll want to match week = 44 AND week = 45.
For example:
IF(OR(WEEKNUM(TODAY())+1={Week Grouping},WEEKNUM(TODAY())+2={Week Grouping}),'Current')
@@GarethPronovost Perfect. Thanks so much..
Hi! I am loving this and input most all of my recipes this week. However, I am having trouble with the "Current Week" not auto populating my "Current Ingredients". It seems that only Saturday, Sunday, and Monday are appearing in the current ingredients. The rest of the week, Tues-Fri, are not there. Have you ever had an issue with this? Would appreciate any thoughts!
Great system you have going here! I was thinking of building something similar. If I was going to add anything to this, I would add a way to sort each recipe by complexity or how long each one takes to prep. There are times where I don't have a lot of time for prepping so I want to add in a meal that doesn't take long to prep on those certain days. Another sorting feature would include the cost per meal. It would be a good way to sprinkle those in my plan so that I'm not spending so much on groceries.
Thanks for watching and for the tips!
Thank you so much Gareth!
Glad to help!
You are amazing!! Thank you for sharing xxxx
Glad you liked it!
Love it! I've been planning to build my own system, I'm sure I'll be using some of your ideas from this. Great design!.
Thank you! 🙌
Legend, thank you very much, brother :)
These comments mean so much to a small channel like ours. Thank you!
Hello Gareth. how do you share in read only mode?
When you share, there's an option about limiting access to your recipient. The lowest available permission is 'read-only'
I am going to try this. Thank you! Too bad you can’t share the ingredients!
I shared a few in the template! 😉