How to make a calculated column blank if other columns doesnt have any values?

Question

This is my format in the calculated formula:

=TEXT([Column2]-[Column1];"hh:mm:ss")

I have value "2018-12-13 10:10:23" in Column1 but when Column2 is blank the calculated column shows "10:10:23" based of Column1.

Is there anyway to make it blank or say some text instead?

Tried this code in calculated column but with no success:

=IF(ISBLANK([Column2]);"no value";)=TEXT([Column2]-[Column1];"hh:mm:ss")

Mike Smith - MCT · Accepted Answer · 2019-11-13 01:46:43Z

2

IF has three parts, condition, result if true, result if false.

=IF( a>b, "a is greater", "a is not greater" )

So:

=IF( ISBLANK(Column2); "no value"; TEXT(Column2-Column1;"hh:mm:ss") )

or

=IF( ISBLANK(Column2); ""; TEXT(Column2-Column1;"hh:mm:ss") )

answered Nov 13, 2019 at 1:46

Mike Smith - MCT

6,7972 gold badges12 silver badges21 bronze badges

Thanks, it finally worked! But for some reason I had to put [ ] in the code. Do you know why? =IF(ISBLANK([Column2);"Inte påbörjat";TEXT([Column2]-[Column1t];"hh:mm:ss"))
– 288088
Nov 13, 2019 at 13:49
Square brackets are only required when spaces or other special characters are in the column's name. "Column1", optional, "Column 1" required.
– Mike Smith - MCT
Nov 13, 2019 at 21:56

Add a comment |

1 Answer 1