Cross Sheet Updating
My company builds meal plans for clients and we have a master sheet in Smartsheets that includes each meal and the calories/protein/carbs/fats. We then link this mastersheet to meal plan sheets and use a drop down for the type of meal and then vlookup to generate the calorie info etc. Everything pulls from the mastersheet. If we update the calorie info it will automatically update in the sheets but if we update the name of an item it shows up as an error in sheets.
Any ideas to try to fix this?
Help Article Resources
Check out the Formula Handbook template!