We have a project intake form + project that’s reviewed weekly. To help catch urgent requests, we’d like to set up a rule that prompts Asana to send an email if the due date listed in the request form is within 10 days of the submission date. Is there a way to set this up without using AI credits?
You can likely achieve this using a formula field instead of AI Studio.
Would the following approach work for you?
The key is to use the advanced editor for the formula field and append +0 to the expression.
Adding +0 ensures that the result of the date subtraction is output as a numerical value rather than a duration.
This allows you to set conditions based on a numerical field—specifically, enabling you to define criteria where the start date is today or earlier, and the due date is today or later.
For more details, you might find this helpful.
Echoing ka_nishiyama — the formula-field workaround is solid and runs reliably without AI Studio credit spend. One thing to watch: make sure the numerical output field is added to your project library so the rule condition can actually see it. And since the intake project is reviewed weekly, pairing it with a daily rule check would flag urgent requests the same day instead of waiting for the review.
Hi Sarah,
You can do this without AI Studio. Because the rule runs at the moment the form is submitted, "within 10 days of the submission date "is the same as “due within the next 10 days from today” at that moment.
Suggested rule:
- Trigger: Task added to this project (or Form submitted).
- Condition: Due date is before 10 days from now (custom rules support relative dates in date conditions).
- Actions: Set a Priority field to ““Urgent”” and/or move the task to an “Urgent” section, and add the reviewer as a collaborator or post a comment @mentioning them. They’ll receive an email notification based on their notification settings.
If you need an email to go to a specific address (for example a shared inbox), use an email integration action if it’s available on your plan, or a Zapier/Make flow triggered by the “Urgent” field.
Alternative (no relative-date condition): create a formula field = Due date minus Created date, with “+0” in the advanced editor so the result is a number, and use the condition “formula field is less than or equal to 10”.
Hope this helps.