Hello guys,
I need your help to solve this formula. I use this formula if([Cadence]=“weekly”,
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 7)),“”) for an action “set values of some columns in this row”.
how to combine above formula with other expression like
if([Cadence]=“monthly”,
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 30)),“”)
and
if([Cadence]=“quarterly”,
if(
isblank([add_date]),
[planned_start_date],
([add_date] + 90)),“”)
I used “and” to combine them, but it doesn’t work. Thank you very much for your help