I want to calculate a Due Date based on a defined Frequency.
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

@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

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

@Lindsay AR  THANK YOU!!!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.8K Get Help
 406 Global Discussions
 219 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!