Forum Discussion
to ADD or REPLACE?
I'm trying to add another function to an existing step. Currently, I have a properly functioning formula of: =IF(ISBLANK($H7), "", TODAY()-$H7) which, when date column H is blank, so also, is da...
:( i've got a bit lost trying to visulaise it all.
Can you use something like if(isnumber(g3),true,false) to change the behavior depending on g3.. dates are recorded as a number, even if they are formatted to look like something else, so if isnumber is true you can assume that its a date, or know that its not text.
Lets try a visual...