Forum Discussion
Calendar Help
I am trying to include the Name, Room, Unit, Provider, and Event Type to show on the month calendar together. How do I do that?
Peter, they are in one line here and separated with "/"
I am basically playing but I found a TEXTJOIN delimiter to be the named formula
=CHAR({10,47,47,10,10})
worked well in the formula
= IFERROR( TEXTJOIN( delimiter, TRUE,
VLOOKUP( CurrentDate, ImportantDates, {2,3,4,5,7}, FALSE ) ),
"")
| Doe, Jane 128B/1B/43632 30 Day Evaluation |
Yes, that's much better. I'd only use as delimiter
=SUBSTITUTE({"X"," / ","X","X","X--------X"},"X",CHAR(10))not to limit delimiter by one character. Plus VLOOKUP returns only one (first found) record. Finally
=TEXTJOIN(delimeter,TRUE, IF(ROW(Important_Data_Only)*(Important_Dates_Only=Current_Date)*(Important_Data_Only<>""), Important_Data_Only,""))