Looking for Formula Help for Mental Health Tracking Worksheet
I work in mental health and I use a spreadsheet to track client engagement
What I do is I have 4 columns that represent my 4 engagements/month on each client line - I fill in each engagement section as I have engaged each client. When I reach 4 engagements, I want it to place an X in the next cell (BINGO) and color it green, letting me know that I have achieved the monthly goal for that client.
Do I need to do this line by line or is there a way to apply it to all of my active client lines?
There is already conditional formatting for the red to go away when I have filled in a cell to no longer be blank, but I'd like it to automatically place the X and change the color in that final box so that I can better keep track of my efforts and I can see these things at a glance rather than having to process the information by hand.
Explanation on the photo - essentially, when the red sections are full, I want there to be an X in the BINGO column
Thank you!
[link] [comments]
Want to read more?
Check out the full article on the original site