Create a table referencing another sheet
Hello Smartsheet experts I am looking for some guidance. I have one sheet "H&S Inspections" and now I'm trying to create an "H&S - Inspection Matrix" sheet.
My monthly inspections log is set up: "H&S - Inspections with Form"
What I want to do is create a table which shows that each location has completed a monthly inspection.
I've tried VLOOKUP and IF formulas but I just can't figure out how to get the formula right.
What I want to do is have the formula reference sheet "H&S - Inspections with Form". If an inspection was completed in "MAY" I want my tracking sheet to display the date the inspection was done.
All help greatly appreciated! 😀
Help Article Resources
Check out the Formula Handbook template!