Cross sheet/ MATCH formulas
I am working on a few new smartsheets that tracks our sites incident reporting data.
I know I can work a COUNTIFS formula to do what I want, but i need the data in the summary to formulate based on the criteria at the top (circled below)
I need the 2 sheets to cross check each other and match weeks, periods and years.
So below, on the first top left "Accidents weekly total" table, The first aid box will need to count anything that is a first aid, that occurred in 2021, period 7, week 27.
, and for health care and lost time I need them to calculate the same, but for "Health care" and "Lost time" instead of "first aid", but also not equal to "Denied" in the claim status column
Here is the sheet I am looking to pull from. Claim status is where you would find the "denied" choice
I cannot show the data due to sensitive content
Once i know how to get the data to match between sheets, I should be good to go from there
Help Article Resources
Check out the Formula Handbook template!