I sometimes find the official formula help in Coda a little unclear. On the other hand, sometimes one needs to string a few formulas together to achieve your goal.
I am adding some information to this doc based on my experience, and will continuoulsy update it.