Menu
How would I specify if a column is not empty or blank in an IF statement - in a calculated column formula?
427
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.
You can use formulas and functions in SharePoint lists or libraries to calculate data in a variety of ways.
There is a function ISBLANK([Column Name]) that you can also use:
=IF(ISBLANK([My Column]),"EMPTY",[My Column])
you can use the LEN([column]) function i.e.. IF(LEN([column]) > 0,'yay','nay')
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
