Trouble creating formulas for task age and due date in KPI dashboard

App Development Data Builder
1

How can I correctly create the following formulas for my KPI dashboard?
I’ve been trying for hours to get them to work:

  • Task Age: NOW() - Created At → current age of the task (for active tasks)

  • Task Due In: Task Deadline - NOW() → days left until the deadline (negative = overdue)

Any idea how to make this work properly?

2

I would recommend using chatGPt to quickly develop the equations.

you need to use the { } brackets around files names.

3

Hi @JurIvk There are two difficulties with what you are wanting to do.

  1. Avoid using system fields directly in equations. The ‘Created At’ field is system generated, and fields like ‘Created At’ or ‘Record ID’ are unusable in formulas. It’s better to create your own Date/Time field, such as ‘EnteredOn’, and set up a record rule to insert the current date and time when the record is created. If you already have records but no such field, you can also add a record rule to copy the value from ‘Created At’ into ‘EnteredOn’, however you then hit the second problem…
  2. Equation recalculation behaviour. Your ‘Task Age’ equation field containing the equation: DATEDIFF(NOW(), {EnteredOn}) will only update when the record is modified. This means the task age value will stay the same until the record is edited or an automation updates it.