http://www.endusersharepoint.com/STP/ SharePoint QA en Sun, 12 Jul 2009 15:48:08 +0000 http://www.endusersharepoint.com/STP/topic/back-for-more-calculated-column-fun#post-8262 Wed, 08 Jul 2009 15:14:50 +0000 NancyCentury 8262@http://www.endusersharepoint.com/STP/ <p>Thanks do much for pointing me to this- it worked great! </p> http://www.endusersharepoint.com/STP/topic/back-for-more-calculated-column-fun#post-8238 Wed, 08 Jul 2009 03:51:39 +0000 Toni 8238@http://www.endusersharepoint.com/STP/ <p>You are looking to create exactly the same thing as Christophe did here: <a href="http://pathtosharepoint.wordpress.com/2009/06/26/case-study-kpi-roll-up-in-moss-1/" rel="nofollow">http://pathtosharepoint.wordpress.com/2009/06/26/case-study-kpi-roll-up-in-moss-1/</a></p> <p>Combine his article with formulas we posted yesterday. </p> http://www.endusersharepoint.com/STP/topic/back-for-more-calculated-column-fun#post-8233 Tue, 07 Jul 2009 17:41:55 +0000 NancyCentury 8233@http://www.endusersharepoint.com/STP/ <p>OK- now I have a new scenario where colored indicator dots (as we were shown in previous workshops) may be useful.</p> <p>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.)</p> <p>NEEDED: formula for a color-dot indicator that does the following:</p> <p>1) If status = In Progress and current date is less than warning date, show GREEN dot<br /> 2) If status = In Progress and current date is during the "warning period," show YELLOW dot<br /> 3) If status = In Progress and current date is equal to or greater than Due Date, show RED dot.<br /> 4) If status = Completed, show no color. </p>