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.
Changed formula to " =UPPER(TEXT(TODAY();"YYYY")) " and it work.