Skip to Content
avatar image
Former Member

Dashboard combo box current year as default value.

Having difficulty on setting current year as default value. Formula for the cell in spreadsheet "=YEAR(TODAY())" and point selected item to this cell. But nothing show up just empty default value. Value is loaded in but default value is empty.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jan 12, 2015 at 02:21 AM

    Changed formula to "  =UPPER(TEXT(TODAY();"YYYY"))  " and it work.

    Add comment
    10|10000 characters needed characters exceeded