Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

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

Topic Labels: Formulas
Solved
Jump to Solution
4184 10
cancel
Showing results for 
Search instead for 
Did you mean: 
David_Voynow
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
David_Voynow
4 - Data Explorer
4 - Data Explorer

Oh awesome thanks again