I have a question, I hope some can help me for a sport association I am making a table in which we note the members.
when new members come, we create a new row in google sheets.
- In column A the year of birth,
- In column B the name of the player
- In column C I have a formula that records the birth.
- In column J write down which team this player belongs to.
currently I have to manually copy these formulas by copying when there is a new member.
I've tried a lot in recent weeks, but I can't find a working method that automatically fills in these formulas when filling in a new line. does anyone have an idea what i can do?
These are the formulas:
column C: =ArrayFormula(IF(ISBLANK(A11)=true,"no date";YEAR(A11)))
column J: =ArrayFormula(IFS(C11="no date";"no date";$C11=($H$3);"F";$C11=($I$3);"F";$C11>( $I$3);"CCC";$C11<($H$3);"E"))