Questions tagged [isblank]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
2 answers
58 views

Multiple IF statement in one calculated column

I have tried everything, can someone help me with this? =IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),IF(NOT(ISBLANK([Date1),DATEDIF([Date1],[Date2],"d")))) It keeps saying ...
Kaz Wilkinson's user avatar
0 votes
0 answers
30 views

Calculated (calculation based on other columns) IF OR ISBLANK AND Sharepoint Lists error formula

Can anyone help? I can't work out why this is erroring. this section =IF(OR(ISBLANK[Tech £]),"", at the start in bold makes it error. =IF(OR(ISBLANK([Tech £])),"",IF(AND([Tech Pay ...
Kirk Norton's user avatar
4 votes
1 answer
4k views

target="_blank" not working in a tag SharePoint online [closed]

The target="_blank" not working for a tag when used in SharePoint online.
Patrick Jane's user avatar
0 votes
1 answer
33 views

Need help with displaying text depending on choice

I am trying to get this formula to work. I want: IF column ärende tilldelat is blank I want the calculated column to say "Ej tilldelad". If you have chosen "Tillkoppling" in the column Ärendetyp I ...
288088's user avatar
  • 129
0 votes
1 answer
334 views

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

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" ...
288088's user avatar
  • 129
0 votes
1 answer
271 views

Blank or empty field in a list item using JavaScript

What is considered an empty SharePoint list item when doing if else condition via JavaScript? "", null, or something else?
adams-j's user avatar
  • 307
1 vote
3 answers
2k views

I want to display a blank field in the calculated column if both the reference fields are blank

I want to display a blank field in the calculated column if both the reference fields are blank, but SharePoint displays the default date as 30-Dec-1899. Formula I used in Calculated column: =IF(...
Deepak Nagaraj's user avatar