Calculated column to enable “does not begin with” list filter

It has always baffled me why SharePoint offered a “Begins with…” filter parameter but did not offer “Does not begin with…” to meet the opposite need. Clare Stone offers a brilliantly simple solution to this aggravating problem in her Pentalogic SharePoint Blog post, “How to Create a SharePoint ‘Does Not Begin With’ Filtered List View.” Calculated columns to the rescue again!

I also recommend downloading their Calculated Column Cheat Sheet for a great resource to keep on hand when you’re stumped about calculated columns.

See all Clare’s posts on the Pentalogic SharePoint Blog


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s