Hi, yes that’s correct I’ve tried to keep it simple for this tutorial and for most cases where a single selection is required. Making it dynamic for multiple selections is possible you could do it in a few different ways. For example, an if statement that looks for the pivot to show “(multiple selections)” and if it did a further you could then point a textjoin formula at another pivot which gave you those individual selections to return “for February, March and April” for example. Hope that helps
Brilliant!
Amazing! I've never seen the BUILD formula before. I can definitely use that one. Thanks from Vancouver 🇨🇦 !!
Glad you like it!
Great Tutorial! Thanks!
And such a handsome host too !
Sadly it’s just good lighting Stephen!! (It’s like virtual Botox) But thanks anyway
Excelent, very nice.
But, if you select two months (or more), the selection of the title will not shown both months.
Hi, yes that’s correct I’ve tried to keep it simple for this tutorial and for most cases where a single selection is required. Making it dynamic for multiple selections is possible you could do it in a few different ways. For example, an if statement that looks for the pivot to show “(multiple selections)” and if it did a further you could then point a textjoin formula at another pivot which gave you those individual selections to return “for February, March and April” for example. Hope that helps