AnsweredAssumed Answered

Field calculated value formula help please

Question asked by Jess Vozzo on Aug 31, 2016
Latest reply on Sep 7, 2016 by Parvezalam Kaliya

Hi All - First post here, need some help with a calculated value formula please:

 

Have a contact field, ABC Ranking with list values, A, B, C, X, Z

Have a second field, Date of Last Communication Data Type: Date

Just created third field, Next Contact Due, Data Type: Date

 

Want to create a formula that says

If (ABC Ranking = “A”, Date of Last Communication + 7

If (ABC Ranking = “B”, Date of Last Communication + 30

If (ABC Ranking = “C”, Date of Last Communication + 60

 

Can anyone please help me with the formula?

Using Sugar Professional On Demand 7.7.1.1

Outcomes