Creating a calendar within Google Sheets using data within sheet
Hello!
I'm looking for some help using an array formula to import data from one sheet and into a calendar, but I'm getting a parse error in my formula. My goal is to create a quick view of what has been scheduled from information within the data. Please see formula below: =ArrayFormula({filter((Data!I2:I15000;Data!I2:I15000<>"")\iferror(text(filter(Data!K2:K15000/(month(Data!K2:K15000)= SEQUENCE(1;12));Data!I2:I15000<>"");"mmm-dd"))}))
I'm still very new to Excel so this formula was borrowed. Any help at all would be greatly appreciated, thank you!