IF Function

CIp

Hi - I tried using this formula

=IF(Status@row, "Open", TODAY() - [Date of Intake]@row)

And it's giving me INVALID DATA TYPE

Subtracting the date of intake from TODAY() worked, so I think it's my IF function, but I can't figure out what it is… my [Status] column is made up of a dropdown of options (Open, In Progress, Closed) - I would like for the formula to show how many days the intake has been open for IF the intake is still Open in the Status column.

CIp

So sorry, I think I solved it. I don't know how to delete this question :D

TomD

Hi @Clp,

The issue with your formula is with the logical expression. It should be Status@row = "Open". Try inputting the formula below:

=IF(Status@row = "Open", TODAY() - [Date of Intake]@row)