If you are a regular follower of this site, you know that I have a high regard for Christophe's No Deployment Solutions at

**Path to SharePoint**. I use his solutions in the live online workshops, especially when it comes to color coding lists and calendars. One of the problems with "rolling your own" when it comes to these solutions is that most people are novices when it comes to creating forumulas. Dessie Lunsford has provided a tremendous resource when it comes to**Taming the Elusive Calculated Column**, but when you need a quick one-off to setup a color coded list, it's tough to spend an hour hunting and pecking for the right formula. Help is here with Christophe's**online calculated column formula generator**. Choose the colors you want to display for each value in a Status column, press the button and "Voila!", you' ve got a forumla. This is going to be a great addition to your tool kit when creating HTML forumulas in your calculated columns. Take a look and let me know what you think. I'm already using it and I only found it 15 minutes ago!**Screenshot of the Calculated Column Formula Generator**

## Comments

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

Thanks

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

I've actually done it myself, but would have to dig back to remember what the operator is. It's easy to do if the seperator is a unique value in the string... harder if not.

-- Mark

SharePoint Calculated Column formula generator

The current values are like this:

2000-01 (CF)

2000-122 PRO

20001-77 (INT)

etc... what I need to do is split the first code (item number) from the second string which is the item type acronym...

I'll have a look through the column and eBook by Dessie.

Thanks

Robin

SharePoint Calculated Column formula generator

Left column formula:

=LEFT(Original,FIND(" ",Original)-1)

Right formula:

=RIGHT(Original,FIND(" ",Original)+1)

I found this in an old forum conversation Dessie and I had:

http://www.sharepointblogs.com/forums/p/18307/39375.aspx

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

SharePoint Calculated Column formula generator

Create a custom column that defines who the item is for. I usually call it "Original Author" or something like that.

Create a calculated column that uses the "Choose" function to dispense your colors.

Filter by the calculated column to determine the color displayed in the calendar or list.

Hope that gets you started, because I don't have time for much more :-)

SharePoint Calculated Column formula generator

http://www.endusersharepoint.com/?p=1563

-- Mark

SharePoint Calculated Column formula generator

Thank you so much for your time and reply. I realize your time is valuable. If you get a few more moments you can afford me I will be especially grateful.

Item 1 - I've created the custom column - should it be a look up, a choice (with 24 names) or does it matter.

Item 2 - create a calculated column - can you please send me a sample of this so I can plug in where I need to. I have this as a start: ="

Again, I realize you're very busy -- your assistance is truly appreciated.

Thank You

SharePoint Calculated Column formula generator

I would use a look up list for that number of items. Much easier to manage.

> Item 2 - create a calculated column - can you please send me a sample of this so I can plug in where I need to.

Look at Jim Bob's screencast referred to above. He goes through the process step-by-step.

Regards,

Mark

SharePoint Calculated Column formula generator

item 2 - 24 "items" is a lot, so you won't be able to use IF statements (at least not in one single column). The easiest way would be to assign a number to each person (1. Jane Doe, 2.etc.).

SharePoint Calculated Column formula generator

In the case you described, you would then be able to calculate off the number, formatting using the choose function.

-- Mark

SharePoint Calculated Column formula generator

A workaround would be to use a workflow to push the lookup to a standard text column, but it sounds like an overkill here.

@David: to precise my first reply, the usual recommendation for color coding is ~6 colors max. With 24 choices you are going to give your users a hard time.

SharePoint Calculated Column formula generator

## Notify me of comments to this article

E-mail:## Add Comment

Title:Comment:

Name:

Url: