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


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


Leave a Reply

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

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

Google+ photo

You are commenting using your Google+ 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 )

Connecting to %s