Google Sheet Coding for User Ease of Use - 01/05/2018 22:44 EDT

Seeking someone who knows Google Sheets intimately, and can code a number of sheets to grab and process information from numerous sheets. Currently we've created multiple sheets to co-ordinate weekly plans for our customers, but we need some deeper information coded into the sheet to process random selections from different criteria, and to have test and submit buttons integrated into the sheets themselves. Hopefully we can find a wizard to process the following tasks: Sheet 1 1. Have the "Suggested" Column auto-populate recipes that currently have low "Times Used" scores from Sheet 2. If it's possible to only have them populate based on BUTTON push that's built into the sheet that would be amazing! Or if that's not possible, having a form set up to show this list, generating only once per week. 2. Add a submit button to finalize the recipe selections, populate "Last Week's Recipe" with that, and populate the corresponding boxes on Sheet 2 for tracking purposes, and increase the "Times Used" on Sheet 3 by 1. 3. Is it possible to have an email generated with the items in Column C from Sheet 1 when the Submit button is pushed? Recipe Creation Form 1. Build a form to enter in the new recipe names, types, macro information, etc and have it update Sheet 3 and the corresponding Meal Type Sheet (ie. Sheet 2 is Breakfasts). At the moment, those are the most pressing items. In the future we're looking at expanding the Google Sheets to include ingredient integration and recipe cards, but that will be decided based on the performance for this project.