SharePoint Calculated Columns IF formula builder

One of my most popular blog posts is originally from 2012 and focuses on SharePoint Calculated Column formulas: SharePoint Calculated Column Formulas & Functions – The Essential Guide – Tuomi Services Ltd.

While many of the questions people ask in the comments are asking about esoteric formulas or some weird quirks, a lot actually can be solved by an understanding of how to effectively structure nested statements in Excel. As explained on the original blog post, SharePoint Calculated Column formulas are almost on par with Excel formulas (with some exceptions).

I found a great resource at
which provides a free (asks for but doesn’t actually require your email address) Excel sheet which is set up to help you prototype “IF” statements.

Instructions on how to use the Excel are on the linked page.

Leave a Reply

Evergreen IT refers to running services comprised of components that are always up to date.

Volunteer firefighters account for 83% of Canada’s total firefighting essential first responders. This petition lets you ask to give them a bigger annual tax credit for their essential work:

Setting up multiple Edge browser profiles for the M365 professional

Microsoft 365 Assessment tool for SharePoint 2013 workflows available now

I've been low-key stressed about how to view the many email inboxes I have in Outlook in one view without having to scroll and hunt for new messages.

The 'macro' method in this video works great.

View Multiple Inboxes at Once in Outlook 365 via @YouTube

Load More