Forum Discussion
Solved
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(I...
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.
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!
