Iโm having problems with the WORKDAY() function.
My input is along the lines of WORKDAY([Start date];10;Holydays[Date]), but it tells me that โWORKDAY has invalid inputsโ
The error goes away when I remove the Holydays[Date] input from the formula, but I have double-checked that all the dates are valid, and formatted as dates in both the google sheet and AppSheets
How about:
WORKDAY([Start date],10,Holydays[Date])
That returns the same error
Hmmmโฆ
is [Date] a date type?
Yes, it is
Double hmmmโฆ
Do you have a Holydays table?
Yeah, my Holydays table is a simple table with two columns: [Date] and [Description]
Iโm seeing the same issue. A manual list of dates works fine but any select function (e.g. SELECT, FILTER, Holidays[Date]) gives that error. I would report this to support@appsheet.com
I Agree. what else is there to ask?
It seems to be working wrongly. I will assign this to our devs for debugging. Thanks for this info!
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |