Daily Update Solution without the need to open the sheet, use Zapier, or similar

Andrée Starå

https://community.smartsheet.com/discussion/comment/445852#Comment_445852

Thanks! I'm glad to hear it's helpful!

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

edmonhill

https://community.smartsheet.com/discussion/comment/358524#Comment_358524

@mvlukas , I have a similar situation with about 40 sheets. I also don't want to put the column in each sheet. I have a couple of questions:

1. When you created your Date Helper sheet, what exactly do you put in that sheet? I just added a date column after the primary and put a date in the first row. Is that sufficent?
2. This may be linked to my first question, but I am struggling with the VLOOKUP to pull in the date field from the Date Helper sheet. Do you have an example of the formula? Do I need to have something else in the Date Helper sheet for the formula to reference?
3. Once you have the date pulled in to the Sheet Summary, do you also create the automation in each sheet? Just wondering how the sheet will know to reference the field in the Summary to know to refresh the sheet.