Hello,
I am attempting to concatenate the result of this function, which shows as "Executive Management Team (EMT)". This is pulling from a set of three boxes, day, month and year and pulling in the value from column D on the "database" tab. I have an integer in column Z on the database page. it correlates to a number of days that the event will run. I want the end result to be, for example: "Executive Management Team (EMT) - 7 days", where the number 7 is in column Z on the Database tab.
=IFERROR(TEXTJOIN(REPT(CHAR(10),2),TRUE,FILTER(DataBase!$D$2:$D$10000,(DataBase!$B$2:$B$10000=(DATEVALUE(E25&"-"&Month&"-"&Year))),"-")," "),"")
This returns the "Executive Management Team (EMT)" in col E, under the 16. Thank you so much, Ninja!
Calendar Screenshot.jpg
Bookmarks