Formula Help

AliT

I am trying to fix a formula. What I am trying to achieve is the number of days between the Assigned Date and the Created Date. The "Executed" is for when the status changes to Executed. I have a status column and date columns following for the statuses like "Assigned" , "Pending" etc. and for each status is a date column that is auto populated.

=IF([Created] = "", TODAY() - [Assigned Date]@row, "Executed") -this is coming up #unparseable

(I don't quite understand the formula above, but it was left by another staff person and I need to fix it)

If I can get it to work right, it would have a number in that column until it becomes "Executed" I hope it all makes sense.

TIA

Ali

Paul Newcome

Give this a try:

=TODAY() - IF([Assigned Date]@row <> "", [Assigned Date]@row, DATEONLY(Created@row))

Paul Newcome

Try changing

[Created]

to

Created@row

AliT

That did work and it's no longer #unparseable but now every cell shows "Executed" Is there something else I need to add or remove to get numbers to appear?

Paul Newcome

What type of column is Created? If it is a system generated Created (Date) type column, it will never be blank which is what you have as your logical statement in the IF function.

=IF(Created@row = "", TODAY() - [Assigned Date]@row, "Executed")

Your formula is basically saying to calculate the days if the Created column is blank.

AliT

Sheesh. Yes, the created column is the system generated one. UMPH. I didn't build this formula and I am fairly new at this. We want a formula that looks at the created date and the assigned date and give me a number of days that it is taking to complete the item, so it also needs to look at today's date unless it's been executed then display that instead of the number. The column the number is displayed is Days to Process.

Paul Newcome

Give this a try:

=TODAY() - IF([Assigned Date]@row <> "", [Assigned Date]@row, DATEONLY(Created@row))

AliT

You are a wonderful person!! That worked!! Thank you so much!!

Paul Newcome

Happy to help. 👍️