Create formula-based rules - just like with excel formulas!

At the moment there aren’t any changes for this planned in the near term by Asana, so I figured we could take it to the community and gather some feedback and votes on the topic, let us know your thoughts and also if you have any loopholes with current Asana rules I am all ears! I was wondering if there is a feature similar to excel formulas where you can create templates in asana that have formula-based rules for example: a graphic should be approved 12 weeks before it’s on-counter date for retailers, and it’s always 12 weeks from the on counter date, is there a way to program this recurring task/auto populate the due date for artwork if you put in the on counter date? thanks, asana community, I appreciate any and all advice!

1 Like

It would be helpful if formula fields were available to use in rules as triggers and if conditions.

For example, we have a project that tracks tickets submitted via form as tasks. I created a “Days Since Request” formula field that calculates the number of days since the task was submitted. I would like to create a rule that adds an “Assign to provider” subtask if the value of “Days Since Request” is greater than 1 and the task is still in a particular section.

Welcome to the Asana Community Forum @ihb :wave:

I have merged your post into am existing feedback request thread. Your vote was transferred as well.