Hello,
I'm trying to create a spreadsheet that can automatically generate meeting dates in a year. I have the current spreadsheet below where I have a dropdown option for column D and a formula in Column E of =LET(s,SWITCH(D2,"Annual",12,"Semi-Annual",6,"Tri-Annual",4),IF(D2="","",TEXTJOIN(", ",,TEXT(EDATE(B2,SEQUENCE(12/s,,s,s)),"mmmm 'y")))). For Column A, I need to be able to pull the months generated in column E and create duplicates for a household if there is more than one month listed in E. This would allow me to sort the spreadsheet my months so we can see who we need to meet with in a given month. Is it possible to do this?
I'm trying to create a spreadsheet that can automatically generate meeting dates in a year. I have the current spreadsheet below where I have a dropdown option for column D and a formula in Column E of =LET(s,SWITCH(D2,"Annual",12,"Semi-Annual",6,"Tri-Annual",4),IF(D2="","",TEXTJOIN(", ",,TEXT(EDATE(B2,SEQUENCE(12/s,,s,s)),"mmmm 'y")))). For Column A, I need to be able to pull the months generated in column E and create duplicates for a household if there is more than one month listed in E. This would allow me to sort the spreadsheet my months so we can see who we need to meet with in a given month. Is it possible to do this?