cancel
Showing results for 
Search instead for 
Did you mean: 

Dashboard combo box current year as default value.

former_member419024
Participant
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

former_member419024
Participant
0 Kudos

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

Answers (0)