I want to calculate a Due Date based on a defined Frequency.

Options
Doris F
Doris F ✭✭
edited 10/27/21 in Formulas and Functions

Audit frequencies are Annually, Biennially or Triennially. I have used the following formula but I get the #UNPARSEABLE output.

=IF([Audit Frequency]@row=Biennially, "[Last Audit Date]@row+730", IF([Audit Frequency]@row=Triennially, "[Last Audit Date]@row+1095", IF([Audit Frequency]@row=Annually, "[Last Audit Date]@row+365", "N/A")))

Best Answer

  • Lindsay AR
    Lindsay AR ✭✭✭✭✭
    Answer ✓
    Options

    @Doris F Try this.

    =IF([Audit Frequency]@row="Biennially", [Last Audit Date]@row+730, IF([Audit Frequency]@row="Triennially", [Last Audit Date]@row+1095, IF([Audit Frequency]@row="Annually", [Last Audit Date]@row+365, "N/A")))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!