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?
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
Yeah, my Holydays table is a simple table with two columns: [Date] and [Description]
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!