Formula values (using Advanced Editor) not showing in task details

Briefly describe (1-2 sentences) the Bug you’re experiencing:
The resulting values of some formulas using the advanced editor do not show up in task details, although they appear fine in the List and Board views, as per below screenshot:

However, in the task details pane, the values appear as ‘Invalid formula’ as per below screenshot:

Steps to reproduce: Create a formula field which includes a date field or a number custom field and then add, subtract, multiply or divide by a simple number. In these cases, the formulas are:
:hourglass_flowing_sand: Duration (days): ( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440 + 0
:hourglass_flowing_sand: Duration (h): ( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440 + 0 ) * 24

This issue is not with just date fields but also with number type custom fields too, with relatively basic formulas such as this: (#Length / 2.54) where ‘Length’ is a simple number field. And regardless of decimal points, the issue persists.

Browser version: Same issue experienced on:
Edge: Version 115.0.1901.188 (Official build) (64-bit)
Firefox: 116.0.2 (64-bit)
Chrome: Version 115.0.5790.171 (Official Build) (64-bit)

What version of Asana are you using (Basic/Premium/Business/Enterprise)?
Phoenix Demo space and an instance on Business plan.


Hi @Richard_Sather, thanks for reporting this and sorry for the trouble! I’ve escalated the case to our Developers and will get back to you as soon as I have an update! :slight_smile:

1 Like

Hi @Richard_Sather, the Developers have confirmed that the issue has been fixed! Let me know if that’s not the case on your end :slight_smile:

1 Like

Hi @Vanessa_N , looks good on my end! Thanks to the developers for the quick turnaround :+1:

1 Like

This topic was automatically closed 16 days after the last reply. New replies are no longer allowed.