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.
Simply, how about this?
=IFERROR(FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20),"")
=IFERROR(FILTER('BP Jobs'!$E:$E, 'BP Jobs'!$Q:$Q=Calendar!F20),"")