Forum Discussion
Miranda Lopez
Aug 14, 2017Copper Contributor
Editing the Community Event Planner Template
Hello All! I have been tasked with creating a conversion calendar for all upcoming software conversions in my company for an upcoming conference. I really wanted to use the "Community Event Plann...
SergeiBaklan
Aug 14, 2017Diamond Contributor
Hi Miranda,
It depend on how you'd like to show your point of contact. If together with Event name (colimn 4) and your Point of Contact is next coulumn, you may simply show the as one string:
=IFERROR(INDEX(tblEvents,SMALL(IF(Dates=C$11,ROW(Dates)),ROW(1:1))-TableRowStart,4),"") &
" " &
IFERROR(INDEX(tblEvents,SMALL(IF(Dates=C$11,ROW(Dates)),ROW(1:1))-TableRowStart,5),"")
Above is array formula, use Ctrl+Shift+Enter.
After you change the formula you may copy/paste it within other calendar entries for one week. For another week you have to repeat, don't copy formula from one week cells to another.