Using calculated fields in a custom form to calculate time

[AWoody]

In a custom form, I have a series of checkbox fields with image sizes on and I would like to know if there is a way to calculate the total number of options selected, multiply it by 0.25 (or 15 minutes) and use a calculated field to give me a total value (of time) it is estimated to take to complete. I am looking at ways of how to show the requestor the total amount of time it is likely to take for their request to be completed and then decide whether the qty they are asking has value for their request before it is submitted.

This total amount of time can also be used within the task in the project.

Does anyone know if this is possible? As currently adding any values to a checkbox field, the value cannot be the same.

Thank you

[SuryaLakhani · Accepted solution]

Hey,

You can use this expression in your calculated field:

ARRAYLENGTH(ARRAY({DE:MultiSelectFieldl},','))*0.25

[AWoody]

Amazing! Thank you so much @SuryaLakhani it worked perfectly