Formula for Invoiced Amount per Invoicing Schedule

Options

Hi Community,

I'm looking for a formula that will divide an annual fee by the # of invoices sent per year. If quarterly divide by 4, if monthly divide by 12 and if semi-annually divide by 2.

I think it's something like this but I can't quite get it:

=IF([O&M Invoicing Frequency]@row = "Quarterly", ([O&M Current Year Fee]@row / 4), IF([O&M Invoicing Frequency]@row) = "Monthly", ([O&M Current Year Fee]@row / 12), IF([O&M Invoicing Frequency]@row) = "Semi-annually", ([O&M Current Year Fee]@row / 2))

Thank you in advance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!