on 01-12-2015 2:01 AM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.