Posted by Sandoval
0 commentsImportant things too know about using TODAY in a calculated column!
http://www.linkedin.com/news?viewArticle=&articleID=185992482&gid=93094&type=member&item=28659782&articleURL=http%3A%2F%2Fblog%2Epentalogic%2Enet%2F2010%2F09%2Ftoday-sharepoint-calculated-default-values%2F&urlhash=q1qF&goback=%2Egde_93094_member_28659782
Posted by SandovalAnother GREAT tip from Christophe at Path to SharePoint
=IF([Status]=””,”Black”,IF([Status]=”Choice1?,”Red”,IF([Status]=”Choice2?,”Gold”,IF([Status]=”Choice3?,”Green”,IF([Status]=”Choice4?,”DarkBlue”,IF([Status]=”Choice5?,”DarkCyan”,IF([Status]=”Choice6?,”DarkRed”,IF([Status]=”Choice7?,”Gray”,””))))))))&IF([Status]=”Choice8?,”MediumSlateBlue”,IF([Status]=”Choice9?,”SpringGreen”,IF([Status]=”Choice10?,”MidnightBlue”,IF([Status]=”Choice11?,”Sienna”,IF([Status]=”Choice12?,”SlateGray”,IF([Status]=”Choice13?,”OliveDrab”,IF([Status]=”Choice14?,”Gray”,””)))))))
Posted by SandovalType in the following formula in a Calculated Column. Replace [Column] with the column you want to reference.
=CLEAN([Column])
Alerts Attachments Calculated Columns Calendar Calendars Checkbox Compare Values Concatenate Contains Crawl Customize Date Field Edit Page Error Folders Form Letter Formulas & Functions History hyperlinks If Then Statement Illegal Characters index indexing InfoPath LDAP Query Master Page Migrate Minutes Move Content Multiple Items Notes Office Outlook Integration Repeat Characters Server Limits SharePoint Designer Solid Line SSP stsadm Task Pane Today Truncate URL Visio Word Count
Posts Feed