How To Default a Choice Column To Day Or Year In SharePoint 2010



TODO:

Have you ever wanted to default the value of a Choice column to the current month or year?

 

SOLUTION:

1.  Create your column, and make it type "Choice"

2.  Populate it with values (ex.  2011, 2012, 2013...)

3.  For Default Value, choose "Calculated Value"

4.  In the text field for the formula enter "=CONCATENATE(YEAR(Today))"   (without double quotes)

5.  Now when you open your new item, that value will be pre-populated with the current year.

 

NOTES:

There may be another way to do this, but TEXT was giving me errors, so CONCATENATE seems to force TODAY to be a string.



Comments (1) -

SabbeRubbish
SabbeRubbish
10/11/2016 4:18:23 AM #

Great, saved me a few grey hairs! Smile

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading