We’d like to have something that automatically populates what grade the student is in this year based on their expected grad year (the grad year doesn’t change, and the school grade level changes each year, so trying to avoid having to go back in and...
I’m trying to figure out a formula to give me the following info in our age of Corona…
I want to put a column on our main table that returns either a ‘yes’ or a ‘no’ based on data from 2 other tables. I’ve got the tables set up to give me a ‘1’ for a...
One more question if I may! I got it all in place and it seems to be working except for I have 1 teen who has an interaction in “weekly 1:1” but not in “weekly interaction” so it’s not returning the yes like I want it to… what’s wrong with my formul...
I think that’s a yes… it all ties back to a teen name/record. So if there is a “1” count on the 1:1’s table or a “1” on the interactions table, all tied back to the same teen, I want a ‘yes’ to show up on the main table next to that teen’s name. Not...
