Using calculated fields in a custom form to calculate time | Community
Skip to main content
W
WorkfrontWhiff
Level 3
April 4, 2025
Solved

Using calculated fields in a custom form to calculate time

  • April 4, 2025
  • 1 reply
  • 473 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by SuryaLakhani

Hey,

 

You can use this expression in your calculated field:

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

1 reply

SuryaLakhani
SuryaLakhaniAccepted solution
Level 4
April 4, 2025

Hey,

 

You can use this expression in your calculated field:

ARRAYLENGTH(ARRAY({DE:MultiSelectFieldl},','))*0.25
    W
    WorkfrontWhiffAuthor
    Level 3
    April 9, 2025

    Amazing! Thank you so much @suryalakhani it worked perfectly

    Terms & ConditionsAccessibility statement

    Loading footer...