Ive got a checkbox called Customer Delay
and a field called Waiting For Customer Days
Ive created a flow to update the waiting for customer days field when the checkbox is ticked -
but im unsure how to create a formula to start a count of working days from the date the box is ticked until the date the box is unticked if anyone could possibly help?
2 réponses
Hi @Conor Snape - you need two fields on the object one to capture the date when it was ticked and one to capture the date it was unticked. This can be captured using record triggered flows. And your ‘Waiting for Customer Days’ should use ticked date and today if unticked date is not available or not in future, and use ticked date and unticked date if it is available.
Please see page 8 in
https://blog.bessereau.eu/assets/pdfs/formula_date_time_tipsheet.pdf for the formula. It uses no of weekdays but does not include holidays. As Mikey suggested, you might the unofficialsf date time methods if you need it to consider the holidays.
