Help
JaclynB
5 - Automation Enthusiast
5 - Automation Enthusiast
since ‎Apr 26, 2023
‎Jun 29, 2023

User Statistics

  • 11 Posts
  • 0 Solutions
  • 3 Kudos given
  • 0 Kudos received

User Activity

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?...
Kudos given to