Questions tagged [isblank]
The isblank tag has no usage guidance.
7
questions
1
vote
2
answers
54
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
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 ...
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.
- 41
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 ...
- 129
0
votes
1
answer
299
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" ...
- 129
0
votes
1
answer
261
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?
- 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(...
