Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Need to Convert a Duration Lookup Field to Numeric

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 t...
Formulas and functions
Quickbase Automations
SuryaExpert's avatar
SuryaExpert
Qrew Assistant Captain
8 years ago
I would check if there is a conversion function for this.
ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago
The conversions I tried (ToNumber, ToHours) still gave me errors saying it was the wrong value.