Displaying a formula produced future date based on one existing date and the selected value of another field

Topic Labels: Formulas
Jump to Solution
2760 10
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I want to use an IF statement in a field where the logic will basically be the following:
IF({Calibration Frequency}= Annual, ({Last Calibrated}+365 days))

I know this isn’t a valid way to code this - strictly an attempt to explain the intent. But basically, the {Calibration Frequency} field is biannual, annual, or 2 years. Depending on that value, i want the field to display the correct “due date” in the coded field based on the calibration frequency and the {Last Calibrated} date.

10 Replies 10
4 - Data Explorer
4 - Data Explorer

Oh awesome thanks again