Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

IF function SharePoint - Not Empty Column

Tags:

sharepoint

How would I specify if a column is not empty or blank in an IF statement - in a calculated column formula?

like image 427
Vin Avatar asked Apr 27 '11 13:04

Vin


People also ask

Can you use if statements in SharePoint?

In this SharePoint Online tutorial, I will demonstrate how to use IF statements in a calculated column. Specifically, I will demonstrate how to use a single IF statement, how to use a IF AND statement and how to use multiple or nested IF statements.

Can formulas be used in SharePoint?

You can use formulas and functions in SharePoint lists or libraries to calculate data in a variety of ways.


2 Answers

There is a function ISBLANK([Column Name]) that you can also use:

=IF(ISBLANK([My Column]),"EMPTY",[My Column])
like image 102
tsap Avatar answered Sep 23 '22 04:09

tsap


you can use the LEN([column]) function i.e.. IF(LEN([column]) > 0,'yay','nay')

like image 45
brian brinley Avatar answered Sep 19 '22 04:09

brian brinley