Workday Function Counting Holidays on Another Sheet


Trying to make a function where it counts holidays referenced on another sheet. The formula I am using is =WORKDAY([Test Out Date]@row, 30, {Reference Sheet Column Location}) and I am getting an "Invalid Data Type" error

Any idea what I need to do? I dont want to include my holidays on the same sheet cause it messes up other formulas



Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Austin Whisenant

    What column type are you putting the formula into? The formula would need to be placed into a Date type of column in order to return a date. This should resolve the Invalid Data Type error!

    Let me know if this works for you.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!