JaclynB - profile

JaclynB · Jun 23, 2023

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 ...

JaclynB · May 03, 2023

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...

JaclynB · May 02, 2023

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...

JaclynB · Apr 26, 2023

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?...

JaclynB · May 23, 2023

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?

JaclynB · May 17, 2023

Hello, any follow up on these issues? Thank you!

JaclynB · May 08, 2023

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...

JaclynB · May 04, 2023

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.

JaclynB · May 02, 2023

Thank you. How do I add the original formula and one of the formulas you provided? Can I have two formulas together? If so, how does it look?

User Statistics

User Activity

Gantt View Settings-Conflicting Fields

Workday formula and Dependency Automation

Leave Blank instead of #ERROR

Add Dates Automatically based on Word

Re: Workday formula and Dependency Automation

Re: Workday formula and Dependency Automation

Re: Workday formula and Dependency Automation

Re: Leave Blank instead of #ERROR

Re: Leave Blank instead of #ERROR