Seeking Formula Help re: Aging

I need to track aging… and that is a formula field; once the task is complete, aging should stop but it doesn't. So I'm looking for help.

In Excel, you have a Start Date and Aging is based on =Today()-Start date. Once Aging completed, you type the total duration and then it's that number and you're done.

In Wrike, I have:

Aging (Calculation) = TODAY()-[Start date]
Aging Override (Manual)… once the task is completed, you type in this field

Now… for reporting, you want

a) if not yet complete, show Aging (Calculation)

b) if complete, show Aging Override (Manual)

the formula should be something like:

IF([Aging Override (Manual)]=BLANK(),[Aging (Calculated)], [Aging Override (Manual)])

IF([Aging Override (Manual)]="",[Aging (Calculated)], [Aging Override (Manual)])

Does anyone know how to do this?

Can Wrike support such a formula?

Find more posts tagged with

Accepted answers

All comments

David Simmington

You can achieve this in Wrike, but the syntax is slightly different from Excel. Instead of checking for BLANK() or "", Wrike formulas use ISBLANK() to test whether a field has a value.

You can create a calculated field for reporting with logic like this:

IF(ISBLANK([Aging Override (Manual)]),   [Aging (Calculated)],   [Aging Override (Manual)])

How it works:

If Aging Override (Manual) is empty → the formula returns Aging (Calculated) (TODAY() - [Start date]).
If Aging Override (Manual) has a value → the formula returns the override value instead.

So your structure would be:

TODAY() - [Start date]
Aging Override (Manual)
Manual numeric field that you populate once the task is completed.
IF(ISBLANK([Aging Override (Manual)]), [Aging (Calculated)], [Aging Override (Manual)])

One additional option to consider: if your process allows it, you could eliminate the manual override entirely by referencing the task’s completion date:

IF(ISBLANK([Completed Date]),   TODAY() - [Start date],   [Completed Date] - [Start date])

That approach automatically stops aging when the task is completed and removes the need for manual entry.

Michael Van Vooren

David Simmington - you are awesome!

Thanks!

that logic makes sense… I APPRECIATE the tip on Completed Date - that is more straightforward and elegant

and I cannot get either formula to work.

I copied and pasted.

I typed from scratch, matching the parentheses,

and

both lead to "Something's wrong, make sure all field named and symbols are entered correctly." in red between the Formula and Format fields.

Searching Wrike's help and the community only finds "ISBLANK" in your post.

Searching I could not find much help… the only formula details I found were specific to the three math operands : +, -, *, /.

Might you know where to find some list of all possible Wrike formulas and their syntax?

formula, with a few spaces:

formula, with all spaces removed:

thanks, Michael

Michael Van Vooren

on a related note…

Aging (Calculated) = Today() - Start Date

its format is in dates

i sought to add those to another date field and could not as the data types did not match.

Is there some formula that lets us add to a date a numeric value and get another date?

Michael Van Vooren

Note to all… Aging Override (Manual) needs to be set to duration

hint / tip

Michael Van Vooren

David… I changed Aging Override (Manual) to duration, and typed 25d and it showed that way and then… converted to 200d.

is there a way to get this to stay as unit of measure (UOM) = days

@DavidSimmington

David Simmington

@Michael Van Vooren, you’re running into two Wrike behaviors here: how durations are stored and how date math works in formula fields.

1. Duration fields are stored in hours. Wrike’s Duration custom fields are internally calculated in hours, based on the assumption that 1 working day = 8 hours. So when you enter 25d, Wrike converts it to 200 hours (25 × 8). That’s why you’re seeing 200h / 200d-equivalent behavior after the conversion. Unfortunately there isn’t currently a setting that forces a Duration custom field to remain strictly in calendar days.

2. Adding numbers to dates. When you add a number to a Date field in a Wrike formula, that number is also interpreted as hours, not days. Example:

[Some Date] + 8

This adds 1 day (8 hours). If you want to add N days, you need to multiply by 8:

[Some Date] + ([Number of Days] * 8)

So the pattern is:

Wrike durations > stored as hours
1 day > 8 hours
Date math > numeric values interpreted as hours

Once you account for that conversion, the formulas will usually behave the way you expect.

Michael Van Vooren

Thank you for that confirmation, David!

Any thoughts on the formula not working?

David Simmington

Hmmm, might need to defer to someone at Wrike for an official answer/solution, but the errors seem to be caused by Wrike not supporting Excel-style logical functions like IF() or ISBLANK().

Read through these two help articles:
1) https://help.wrike.com/hc/en-us/articles/360036858954-Adding-Formulas-to-Custom-Fields

2) https://help.wrike.com/hc/en-us/articles/1500005219342-Formula-Custom-Fields-Possible-Formulas-and-Resulting-Data-Types

Michael Van Vooren

Thanks… I had come across those two links last week.

Have you used ISBlank, successfully?

Can Wrike support "multi-level" formulas… something more than intro-to-Algebra order-of-operations math with +, -, *, and/or / ?

Have you been able to get an equation, similar to the one you thankfully shared, to work?

Michael Van Vooren

Oh… have you not been able to get the formulas to work?

Does anyone know if Wrike supports ISBLANK()?

Does anyone know where to find the list of formulas that Wrike supports?

Challenge statement… seeking a field that we reference for aging… before task is final, this field should [duration from start to today]; once final should be [duration from start to complete]… was hoping could be a calculation… do I need to just update it manually?

@DavidSimmington