This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello, When setting up the Gantt view, I have the start date field as 'start date' which is a date field that is added manually by the user.For the end date field, I want to add 'Due Date test' which is a formula field. If I select the due date test ...
I have a work date formula in the 'end date' column.IF(AND({Start Date},{SLA (days)}), WORKDAY({Start Date},{SLA (days)}))When someone changes the SLA number, start dates and end dates changed because I setup a dependency automation.However, I'm seei...
Hello, I'm current working with this formula: WORKDAY({Start Date},{SLA Test}) ---which is the formula in the 'due date' column.I would like for the Due Date to be left blank instead of #Error if there is no start date or SLA.Can someone help with...
If there are options in a drop down menu (example Quiz or Test), start dates are entered by user, can I add a new column with a formula that detects the word 'quiz' or 'test' in the previous column and add an end date automatically based on the word?...
Thank you so much @Vic.1. Can you show me how to include holidays within that formula? 2. How do I add days off in this formula? For example, we have July 3rd-7th off.3. Also, what does the 'L' stand for?
Thank you so much for your help. I also noticed when trying to add an existing record in the 'Dependent On' field, there are multiple owners who have similar projects (see screenshot). Is there an additional filter or view that will also add the owne...
Thank you for your help. The errors are gone however the formatting is not correct. Can you help me so it shows as a (work) day?Background: When start date and SLA number are entered the due date automatically updates using a work day formula.
