Forum Discussion
Dynamic Calendar Help
I am trying to create a running production calendar which will take the data of all the jobs we have in house and display them on said calendar. This is the formula I have created so far;
=IFERROR(INDEX('BP Jobs'!$E:$E,MATCH(Calendar!F20, 'BP Jobs'!$Q:$Q,0),1),"")
It works great, however, if there are multiple jobs due on the same date it doesn't display those on the calendar. Only the first job in-line. Is there something I can add to the formula to have it display all the jobs due on a certain day?
Thanks in advance for your help.
Do you have Microsoft 365 or Office 2021? If so, you can use
=TEXTJOIN(CHAR(10), "" FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20, ""))
Turn on Wrap Text for the cells with the formula, and make sue that the row height is sufficient to display multiple jobs.
3 Replies
- Simply, how about this?
=IFERROR(FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20),"") Do you have Microsoft 365 or Office 2021? If so, you can use
=TEXTJOIN(CHAR(10), "" FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20, ""))
Turn on Wrap Text for the cells with the formula, and make sue that the row height is sufficient to display multiple jobs.
- Thank you!! This worked perfectly! Happy Holidays!
