Workday Function Counting Holidays on Another Sheet

Austin Whisenant
Austin Whisenant ✭✭
in Formulas and Functions

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


Thanks

Tags:
· Share on FacebookShare on Twitter

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.

    Cheers,

    Genevieve

    · Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!