It’s that time of year when I am paying attention to our app and working out the kinks in our Timesheets form.
This past year, in our Timesheets, we have recorded our [Employee], and then a [Co-gardener] in two separate columns. [Duration] of the visit is recorded, and if a Co-gardener was recorded in the same row, then the [Duration] is doubled to come up with a [Combined Duration]. That is, the combined time spent at the garden.
However, I would like to be able to put up to 4 employees on a single Timesheet, and have the [Combined Duration] calculated from that. So there could either be 1, 2, 3 or 4 employees recorded on the timesheet, depending on the circumstance, and then depending on what is filled in, the Duration is doubled, tripled or quadrupled. Or just kept as is if it’s only one person.
My expression for doubling the [Duration] is:
IF(ISNOTBLANK([Co-gardener]), [Duration] + [Duration], [Duration])
This has worked and has been great!
So my question is, what kind of expression would I need to put together to accomplish the same thing with 4 possible employees instead of just two. Can I still use an If, then expression? Or would it be something else totally different?
Thanks so much!