Automate INDEX/MATCH or VLOOKUP the first date of the week each week.

I want the "Week of" column to automatically show the date of the first day in the current week each week starting with Monday as the first day, and if "Week Of" and "Project Name" both match on another sheet where the data is being enter then I want to return the next 4 columns for the rows where the "Week Of" and "Project Name" both match. I have tried so many formulas, i''m sure I am making this more difficult than it is but I am exhausted now. Please help!

WEEKLY OUTPUT

image.png

DATA:

image.png


Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!