Skip Ribbon Commands
Skip to main content
 

 Select Your Options

 

Target Date Field

Icon Shape



Icon Color - Target Date Not Reached Yet

Icon Color - 0 to n Days Before Target Date


days before target date.

Icon Color - Target Date Passed

Text - Target Date Not Reached Yet

Text - Target Date Passed

 

The formula below is updated dynamically based on your selection.

Paste the following formula in the calculated column that will be displayed in the list or calendar:

 

 Instructions

 

 

The formula generator helps you build a countdown/countup field. It will tell you the number of days left or elapsed between now and the target date.

Note that "now" means the current local date of your computer. If your local time zone is different from the reference used by the SharePoint site, the calculation result might be off by several hours.

To proceed:

1/ Fill out the form. Based on your choices, the formula is automatically updated at the bottom of the form.

2/ Paste the formula in a calculated column in your list.

3/ Get the script available under the Downloads tab and link it to your page, under your list.

The steps are similar to the ones used for the color coded calendar. I plan to publish a tutorial in the future.

 

 Downloads

 
  
  
  
  
  
TextToHTMLlite-v2.1.1.dwp
  
5/21/2011 9:04 AMLight version, for both SharePoint 2003 and 2007 - Applies the rendering to displayed items only.No presence informationChristophe
TextToHTMLlite-v2.1.1.txt
  
5/21/2011 9:04 AMLight version, for both SharePoint 2003 and 2007 - Applies the rendering to displayed items only.No presence informationChristophe
TextToHTML-v2.1.1.dwp
  
5/21/2011 9:04 AMFull version (SP 2007) - Applies the rendering to displayed and hidden items (grouped views, preview pane, etc.). Warning: the script encapsulates some of the SharePoint OOTB code.No presence informationChristophe
TextToHTML-v2.1.1.txt
  
5/21/2011 9:04 AMFull version (SP 2007) - Applies the rendering to displayed and hidden items (grouped views, preview pane, etc.). Warning: the script encapsulates some of the SharePoint OOTB code.No presence informationChristophe
Copyright © 2011 User Managed Solutions, LLC