Formula Output to be recognized as numbers

1166 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello! I am trying to do a sum of days! Here is what I have

IF(Delivery=BLANK(),"", DATETIME_DIFF(Return,Delivery,‘days’))

I am getting a number output of the difference of days, (IR: 2, 7, 14) however they are not recognized as numbers because they are in a formula column, therefore I am unable to see the sum of all those days in my column.

1 Reply 1

Your problem is that explicit empty string in your formula — it causes it to return everything as a string. You can either get rid of it —


— or (my preference), make it unnecessary:


(The latter version says, implicitly, "IF {Delivery} IS NOT BLANK, DO DATETIME_DIFF(), OTHERWISE BLANK().)