🎶 Finally it happened to me🎶 - 5 Top Use Cases For The New Formula Field (so glad it is finally here!)

English Forum Tips and Tricks Forum Leaders tips
, , ,
1
  1. Inventory! - if you are using it to manage stock levels. Have a number field for total units, another number field for units given out to staff then use the formula field to take the total from the given out number and you have your remaining stock! :abacus:
  2. Estimated vs Actual Time Difference!- If you are using estimated vs actual time custom fields, find out the difference between what you estimated a task would take and the time spent on that task. Then you can use the dashboard to add up the total difference between what you estimated the project to be and actual project delivery time - great for retrospectives.:heavy_plus_sign::heavy_minus_sign::heavy_multiplication_x::heavy_division_sign:
  3. Item Monetary Value! - if you are using tasks to record items or stock and their value then add a number field for amount, a currency number field for worth and then use the formula field to multiply them together and you have your total cost for all items. Again you can then use the dashboard to add these together and find out total value for all items.:heavy_plus_sign::heavy_minus_sign::heavy_multiplication_x::heavy_division_sign:
  4. Billable Hours on Tasks! - add a currency number field for hourly rate and then number field for hours, you can then use the formula field to calculate total payment due.:heavy_plus_sign::heavy_minus_sign::heavy_multiplication_x::heavy_division_sign:
  5. Automatic Duration for Tasks!- You can use the due date and minus your start date as your options and it will give you the duration of that task. Alternatively, you can use the completed on minus the created on to find out how long it took to complete each task. :heavy_plus_sign::heavy_minus_sign::heavy_multiplication_x::heavy_division_sign:

Let me know your thoughts and other use cases below!!!

7 Likes
2

Thanks Danielle, great content as per. I know this is already going to spark plenty of new ways of using Asana. Wondering if there is an overview page for this new Custom Field??

3

Here you go @John_Petty : Formula Custom Fields in Asana | Product Guide • Asana Product Guide

1 Like
4

Thanks @Richard_Sather much appreciated

1 Like
5

love it!!! especially your #5, but it only shows in number of days or week not by hours, would anyone know how?

8

Hi @anon2656139 , now that the new Advanced Editor is available, you can achieve the value of task durations in hours by using this formula which you can copy paste into the advanced editor:
( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) + 0 ) / 60
or this one if you want without decimals:
( ( [[$DUE_DATE]] - [[$STARTED_AT]] ) / 1440 + 1 ) * 24

You can also have a look at my recent post where you can do all sorts of things with the new Advanced Editor, here:

2 Likes
9

I’ve been looking at formulas to convert minutes/hours from the estimated and actual time standard fields to a ‘Level of Effort’ custom field, which is basically consulting days. There are 8h in each consulting day.

I’ve got the formula as: LOE-Actual = [Actual Time] / [8], but the LOE field is still showing the results in minutes. Is there a way to change this?

image
image1147×159 10.7 KB

10

Hi @HS-ACG , it should work if you insert +0 after Actual time and then divide by 60 to convert the minutes to hours. Then divide by 8 to get your ‘consulting days’.

I’ve documented several such ‘hacks’ here:

1 Like
11

Awesome. Thanks very much. It worked.

1 Like