Questions tagged [isblank]
The isblank tag has no summary.
7 questions
1 vote
2 answers
75 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 ...
0 votes
0 answers
35 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 ...
4 votes
1 answer
5k views
target="_blank" not working in a tag SharePoint online [closed]
The target="_blank" not working for a tag when used in SharePoint online.
- 49
0 votes
1 answer
40 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 ...
- 129
0 votes
1 answer
584 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" based ...
- 129
0 votes
1 answer
337 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?
- 317
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(...
