Recurring date help or formula help to resolve problem

Support
1

Ok I need some help please as recurring date is Yearly,Monthly,Weekly only. i looking for a way i can use a formula for 4 weekly, 8 weekly
e.g
i have the following setup…
Date called “last done” ( date field )
selection box with 4 weekly, 8 weekly
A Date called " due date " ( date field)

I need a way
if i choose the selection box = 4 weekly, it will auto update “Due date” 28 days
If i choose the selection box = 8 weekly, it will auto update “Due date” 56 days

Not to good at formula so any help would be great

2

Hi,

To better understand you ideal workflow, could you please provide us with an entry example, describe your ideal workflow using that example, tell us what’s not working correctly, and the ideal result for us to refer to first?

3

FUNCTION

IF A1 IS YES THEN A2 IS A3

Can you help

4

Hi,

In this case, the formula should be applied to field A2, and the formula is: IF(A1.RAW=‘YES’,A3)