How to make a field dynamic based on a criteria from multiple fields in the Accounts Module

Question

Hello! 
 I've tried using a few formulas to try to accomplish what we need, but haven't found the right one. I'm super new to Sugar so I'm not familiar with how it all works, but we're getting there! 
 Here's a breakdown of what I'm looking for: 
 If Type_c (dropdown) is Customer and Last Transaction Date (date) is empty, then Account Status (dropdown) is Not Activated 
 If Last Transaction Date (date) is within 90days from today, then Account Status (dropdown) is Activated 
 If Last Transaction Date (date) is after 90days from today, then Account Status (dropdown) is Dormant 
 If Practice_is_Active_c checkbox is unchecked, then Account Status (dropdown) is Deactivated. 
 
 Please let me know how we can achieve this. Thank you!

Joey Maguliman · Accepted Answer

Hi Joey, 
 Are you entering the formula in the Calculated Field part of the field editor, or the Dependent Field part, or the Required If part? 
 The formula I gave you is for the Calculated Field part of the field editor. If the field type you are attempting to calculate does not have a Calculated Field option, then your version of Sugar does not support calculating the content of that field type. (Calculated Dropdown fields is new in 12.3.0) 
 The Dependent Field part is just about whether the field displays in the layout. It is not about populating the field. A formula in this part must be boolean. 
 The Required If part is just about whether the field must have a value before the user can save. It is not about populating the field. A formula in this part must be boolean. 
 Regards, Patrick McQueen Director, SugarCRM Support