I need to calculate different due dates for tasks based on Workday instead of dateadd. Here is my original formula:
SWITCH(
Task,
'Email for photo, new hire survey, and short bio of new hire', DATEADD({Hire Date}, -7, 'days'),
'Assign desk space for new hire', DATEADD({Hire Date}, -3, 'days'),
'Give Uniform', {Hire Date},
'Collect how to contact employee while OOO', DATEADD({Hire Date}, 1, 'days'),
'Verify that background check has been completed', DATEADD({Hire Date}, -7, 'days'), 'Hiring Manager select starting date', DATEADD({Hire Date}, -21, 'days')
)
When i change DATEADD to WORKDAY it gives me an error message. What else do I need to change?
Thanks!
