@Oliver_Atkinson - does this work for you:

The “days since update” field is:

IF(NOT(Completed), DATETIME_DIFF(TODAY(), Update, 'days'))

Hi Jonathan,

I think this would be absolutely perfect however my completed column is a single select field where I select ‘Completed’ how would I amend your formula to reflect this?

Really appreciate your help

Hi Jonathan,

I’ve managed to crack it with:

IF(Status=‘Completed’,“Complete”, DATETIME_DIFF(TODAY(),{Last Update},‘d’))

However as well as ‘Completed’ i also have a status of ‘No further action’ how can I do include this as well? Can i do it with another IF Formula?

Yeah - I did wonder if it was a single select, but as you’ve done, it isn’t too hard to adapt from the checkbox version.

A couple of options on your other question:

1. If you are OK if the two statuses result in a “Complete” value then you can say:

IF(OR(Status='Completed', Status='No further action'),'Complete', DATETIME_DIFF(TODAY(),{Last Update},'d'))

So it it is ‘Completed’ OR ‘No further action’, then show ‘Complete’, otherwise, the days calc.

2. If you want them to show different values:

IF(

  {Status}='Completed',

  'Complete',

  IF(

    {Status}='No further action',

    'No further action',

    DATETIME_DIFF(TODAY(),{Last Update},'d'))

  )

)

IF(

  {Status}='Completed',

  'Complete',

  IF(

    {Status}='No further action',

    'No further action',

    DATETIME_DIFF(TODAY(),{Last Update},'d'))

  )

)

That’s been so helpful- thank you!

I went with the second option which has worked really well. I only originally wanted it to show a 0 when the status is complete/no further action but this is so much better. Really appreciate all of your help

Thanks again