Trouble with my If/and statement formula

Platform discussions
, ,
1

I am trying to create a formula to add a certain number of days depending on which category the task is assigned weight is. If I only do low weight it works so I am doing something wrong when adding the other two on. I have changed it 10 times and now frustrated can someone just look at this

IF(AND({Weight Status}=“Low”,FORMAT_DATE(ADD_DAYS({Date Open})),14,IF(AND({Weight Status} =“Medium”,FORMAT_DATE(ADD_DAYS({Date Open})),42,IF(AND({Weight Status} =“Heavy”,FORMAT_DATE(ADD_DAYS({Date Open})),84,0)))

2

Hi Katina! Does this formula work for what you need?

IF({Weight Status}=“Low”,FORMAT_DATE(ADD_DAYS({Date Open},14)),IF({Weight Status}=“Medium”,FORMAT_DATE(ADD_DAYS({Date Open},42)),IF({Weight Status}=“Heavy”,FORMAT_DATE(ADD_DAYS({Date Open},84)))))

1 Like
3

yes thank you so much