This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
HI. I’m having trouble with a filtered list in an email template. I’ve
got a table (tableX) which includes a filtered list of entries from
another table (tableY) I’m looking to create a workflow email for tableX
which includes various details from th...
Does anyone know how to convert a WEEKNUM number and year to a date, so
as to give the ‘week commencing’ date? I’ve found expression for
Googlesheets and excel but they don’t even begin to work in appsheet.
Thanks!
Thanks Aleksi. Is there no expression which will yield the week
commencing date? In excel the expression is: =DATE(A2, 1, -2) -
WEEKDAY(DATE(A2, 1, 3)) + B2 * 7 where A2 is the year and B2 is the
weeknumber. G-sheets has a similar expression.