Is there a Today field?

@Chantelle_Drury , I understand your frustration. It would be ideal if the value was more granular such as in weeks AND days left. You can actually achieve a more accurate value for the duration of the project because that is based on start and end date of the project which are already available as inputs for a formula. Check out my post here, see the last basic formula in section 2.

Unfortunately, in order to achieve what you need for Time remaining, we would need a ‘Today’ function in order to create a formula field (as I explained above), which would logically provide a more accurate value, similar to the formula for a project’s duration, in my post.

Hopefully it won’t be too long for Asana to follow up with such an update to formulas. I will make sure to post back here when that happens to let you know, and I’ll provide you with the relevant formula too. :wink:

1 Like