What am I doing wrong: =WORKDAY(TODAY(), [Number of Work days in funnel]@row, {Holidays})
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!
Answers

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.
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist  Process Improvement Enthusiast

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

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.

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})
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist  Process Improvement Enthusiast

I just tried that and I still get INVALID DATA TYPE. :(
But thank you for the suggestion!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.4K Get Help
 325 Global Discussions
 183 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!