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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s