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

Options
✭✭
edited 10/27/21

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")))

• ✭✭✭✭✭
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")))

• ✭✭✭✭✭
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")))

• ✭✭
Options

@Lindsay AR - THANK YOU!!!

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!