SharePoint Calculated Column IF Statement: 7 Examples

SharePoint Calculated Column If Statement

A regional manager I work with wanted a quick way to spot overdue work in a SharePoint task list without opening every item. We added one calculated column with an IF formula that labeled each task, and a view that sorted by it. It’s still the column she looks at first every Monday. IF is … Read more >>>

SharePoint Calculated Column Date Formulas (With Examples)

SharePoint Calculated Column Date Examples

A project management office I worked with tracked 200 projects in a SharePoint list and wanted to see, at a glance, how long each project would run and when it would end. They’d been calculating it in Excel and pasting the results back in. A few calculated columns did the math automatically, and the numbers … Read more >>>

How to Create Shortcuts in a SharePoint Document Library

Create Shortcuts in a SharePoint Document Library

At a marketing agency I worked with, the account team opened the same three folders every morning: the brand guidelines on the Marketing site, the client contracts on the Legal site, and their own project library. That’s a lot of clicking through site navigation. Ten minutes of setting up shortcuts saved each of them that … Read more >>>