Chapter 1 – What are formulas?

Formulas are equations that perform conditional checks on column values in a list or library. A formula starts with an equal sign (=) followed by the if function that returns either a true or a false result.

The below example checks to see if the value for the Status column is New.

=if([$Status] == ‘New’, ‘true’, ‘false’)

If true then the column gets displayed, if false then the column is hidden.


YOU MUST specify the internal name of the field

Overview & Preview

11 Pages - full of examples and starting formulas

Every day I get to work in an industry, with people and businesses where I can make a difference in the way everyday work is experienced. I believe in inspiring businesses and individuals to re-evaluate how they operate, communicate, collaborate, and function.

Did you know that you can show or hide columns in a list form based on another column’s value by specifying a formula that are equations performing conditional checks on values in a SharePoint list or library?

Yep, you sure can and not a developer in site.

Sample Pages

Join the Modern Work Collective

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Microsoft Teams and SharePoint Remediation

The Modern Work Collective Microsoft Teams remediation engagement helps you get an understanding and a handle on your Microsoft Teams environment. First step, complete the below form and we will be in touch to organise an initial consultation call.

You have Successfully Subscribed!

Approval Process Automation Masterclass

Learn how to and what the benefits are of automating your approval processes

Please check your Inbox to confirm

The Ultimate Content TypeMasterclass

Learn what a Content Type really is and how to implement them in your SharePoint environment for better inromation management.

Please check your Inbox to confirm