Rounding up a formula return

I am using the following formula to change a date into a billing quarter.

=MONTH([Year-1/Deliverable-1 Invoice Date]@row) / 3

It works well except for any date in January. That returns a value of .3 (1/3=.3). The system automatically rounds that down to 0 which does not work when trying to display a January date as Q-1.

Feburary returns a value that rounds up to 1 which makes sense since Februaury is in Q-1. All of the other months work as expected.

I have tried to nest a ROUND function in to my formula with no sucsess. Can anyone help me with this. I am thinking its something simple that I am overlooking.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!