What am I doing wrong: =WORKDAY(TODAY(), [Number of Work days in funnel]@row, {Holidays})

BFuller

I want to update a formula I have in the Estimated Funnel Fill Date column and I'm getting an INVALID DATA TYPE error. I can not figure out why this formula is not working. Can someone double check me?

Here is the formula I want to use:

=WORKDAY(TODAY(), [Number of Work days in funnel]@row, {Holidays})

The column this formula is in is a date column. I have a column that is returning the number of days in a funnel (project hours /8). I have the same formula structure in another sheet and it works. On this one I'm getting Invalid data type. I can't see what I'm doing wrong.

The old formula is just TODAY + the number of work days in the funnel (work days as in # of hours /8 not WORKDAYS as in a formula).

Thanks in advance for your help!

Amber Eakin

Hi @BFuller - Have you configured {Holidays} as a sheet reference? If you've copied and pasted from another sheet, you'll need to reconfigure that reference.

BFuller

Yes, I have configured {Holidays} to this new sheet.

BFuller

I pulled the formula through the rest of the column and get this. What is strange is the 11/20/24 date return. Why aren't the others returning I wonder. The "Number of Work days in funnel" column has this formula in it.

=SUM([Active PCD touch time hours in the funnel]@row / 8). I was thinking at first maybe it was because of a decimal, but I removed them all and the 808/8 = 101 and it's not a decimal.

When I do the formula as =WORKDAY(TODAY(), 101, {Holidays}), I get a date return, but when I reference the column with the number it in, I get INVALID DATA TYPE. but not on the row with the date of 11/20/24. I have it sent as a column formula on all these columns, so it's the same.

Any ideas on how to resolve this would be most appreciated.

Amber Eakin

This is a sticky wicket. Have you tried cutting out the reference to the helper column and moving the formula directly into the WORKDAY cell? I'm hoping someone else might be able to step in with ideas, too!

=WORKDAY(TODAY(), SUM([Active PCD touch time hours in the funnel]@row / 8), {Holidays})

BFuller

I just tried that and I still get INVALID DATA TYPE. :(

But thank you for the suggestion!!