Skip to main content
Question

Need to Convert a Duration Lookup Field to Numeric

  • September 22, 2018
  • 0 replies
  • 88 views
I have a Duration Lookup field from another table, and I want to create a checkbox formula that says yes or no if the lookup field value is greater than zero. The ultimate goal is to have a checkbox that will limit a trigger in a Workflow Automation (only change the records where the box is checked).

All of this is a way to try and get around the limitation in Workflow Automations with duration fields.

Example of logic: IF ( [TSK - Est. Edit Time] > 0, TRUE)

Every fix I tried to apply told me I was using the wrong type of field.

This topic has been closed for replies.

  • SuryaExpert
  • Registered
  • September 22, 2018
I would check if there is a conversion function for this.
The corrected formula is this

IF([TSK - Est. Edit Time] > Hours(0), TRUE)

or you can also write is as just this


[TSK - Est. Edit Time] > Hours(0)


Terms & ConditionsAccessibility statement