There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
Here's how I figured out HH:mm. I welcome all simplification suggestions. The combined formula in A38 is this monstrosity (but it works): =IFERROR(IF(INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60) < 10, "0" + INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60), INT(SUMIFS({Duration}, {CURWK}, 1,…
This one comes up a lot, so I thought I would provide a few ways to solve it. The question is this: can I use the OR function in the CONTAINS function? For instances, you want to see if a cell contains "apple", "banana", or "orange". In short, you can't use OR in the CONTAINS function (TLDR: because OR provides binary…