Stump the Panel Topic: Back for more calculated column FUN!

NancyCentury on "Back for more calculated column FUN!"

NancyCentury — Wed, 08 Jul 2009 15:14:50 +0000

Thanks do much for pointing me to this- it worked great!

Toni on "Back for more calculated column FUN!"

Toni — Wed, 08 Jul 2009 03:51:39 +0000

You are looking to create exactly the same thing as Christophe did here: http://pathtosharepoint.wordpress.com/2009/06/26/case-study-kpi-roll-up-in-moss-1/

Combine his article with formulas we posted yesterday.

NancyCentury on "Back for more calculated column FUN!"

NancyCentury — Tue, 07 Jul 2009 17:41:55 +0000

OK- now I have a new scenario where colored indicator dots (as we were shown in previous workshops) may be useful.

Upon creation of a new project on the list, the workflow action "add time to date" creates variable called "warning date" which = three days before the due date. Those three days would constitute a sort of "warning period." (I am not sure how to allow for this.)

NEEDED: formula for a color-dot indicator that does the following:

1) If status = In Progress and current date is less than warning date, show GREEN dot
2) If status = In Progress and current date is during the "warning period," show YELLOW dot
3) If status = In Progress and current date is equal to or greater than Due Date, show RED dot.
4) If status = Completed, show no color.