Forum Discussion
Solved
Cell formatting based on other cells content
I have a tracker that I am using for observations. I would like to be able to auto populate the next observation box based on the grade of the current observation (Drop down) and the key (Green =+6...
Let's say the date last observed is in A2, and the current grade in B2
In D2:
=EDATE(A2,IF(B2="RED",1,IF(B2="AMBER",3,IF(B2="GREEN",6))))
or
=EDATE(A2,IFS(B2="RED",1,B2="AMBER",3,B2="GREEN",6))
This can be filled down
See the attached version. I changed the month names to dates (in 2022), formatted as mmmm to display the full month name.
Hi Hans,
when i extend this for the whole column i get #VALUE!
This is what i have put in the cell - =SUM(--($G$13:$G$90-DAY($G$13:$G$90)+1=D1))
Any ideas? Thanks for your help so far.
when i extend this for the whole column i get #VALUE!
This is what i have put in the cell - =SUM(--($G$13:$G$90-DAY($G$13:$G$90)+1=D1))
Any ideas? Thanks for your help so far.
Could you attach a workbook demonstrating the error?
HansVogelaar Hi Sheet 2 is a copy of the sheet i am trying to input it in to. thanks so much for your help.