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 f...
Hello!I would like to create a field that shows when (date and time) a record (task) has been marked as "Done". Here is what I have so far: How do I create a formula and/or automation to do this? TIA!
Hello!I was recently helped on another post to create parameters for the dateadd function. However, it is not calculating dates correctly. Why? How do I fix this?Here is my function:SWITCH( Task, 'Email for photo, new hire survey, and short bio of ...
Hello!I am wanting to add a DATEADD formula to my base to set deadlines for different tasks based on a hiring date. I've done this in a previous base, but have since lost access. Can someone help me with the formula I need? For reference, some of the...
I do have one question about this - I noticed that it wasn't calculating correctly. ie it showed that Give Uniform was one day before the hire date, the survey and bio was 8 days before, etc. etc. Why is it off by one day?
When I tried your solution, I got a date for the first one, and the others say #ERROR The "tasks" are the first column for each record in a single line text field. Not sure if that matters!
