Calculated Column – Smart Column


Get the day name

TEXT([Created],”dddd”) ===> Saturday

TEXT([Created],”ddd”) ===> Sat

Determine the time is in day or night

IF(AND(HOUR([Created])>7,HOUR(Created)<18),”Day”,”Night”) ==> Day

Choose a value randomly based on current time

CHOOSE(MOD(TEXT([Created],”s”),2)+1,”V1″,”V2″)

Determine if the current list item changed or no

IF([Modified] > [Created], “Changed”, “Not Changed”)

Convert value to text

TEXT([Created], “yyyy|mm”) ==> 2012|04

Check whether the field is empty of not empty

ISBLANK ([Cost])

Choose Statement

CHOOSE(int, Val1, Val2, <up to 29>

Example : Choose(5,”V1”,”V2”,”V3”,”V4”,”V5”,”V6”) ==> V5

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s