Hi Hector,
I think your issue can be solved but it will require playing with some smartvalues,
Things you would have to set up:
- 2 Date fields for date calculation
- Custom field1 that would hold value of difference between needed date and other custom field2
- Custom field2 that would hold value of original difference between dates
Automation1:
Trigger: Daily at the start of your working day
IF1: If Customfield2 is empty
- Action: calculate the difference between Datefield1 and datefield2 and put it in customfield2
{{datefield1.diff(datefield2).abs.days}}
IF2: IF Customfield2 is not empty
- Action: calculate value at what date user should be notified: (customfield1)
{{#=}} {{customfield2}} / 2 {{/}}
and compare this value to 0
IF2.1: IF value calculated in IF 2 will be 0 or less than 0 then send email notification.
Quick note on that I have tested these as simple automations, haven't really composed them all together so you still might need to check if everything works properly. If you have any questions let me know. Hopefully that will help you:)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.