I looking for a column Description expression that will return the following text value for column 1 (i.e. Week 1)
Wk 1: Mon, 2 Jan 2023
It does this by looking at the Column Name number 1 as well as the year of Today() i.e. 2023 and then returns the date of the 1st monday of week 1.
I not sure if you able to return the relevant column name dynamically within Appsheet, but I do not mind "hard coding" the week numbers for each column expression (i.e. 1, 2, 3....)
Also factor in that I am using an ISO week numbering type
ISO week date - Wikipediar
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |