How to recreate a payment month Excel formula in Smartsheet

SteCoxy
SteCoxy ✭✭✭✭✭✭

Hoping you might be able to help me with migrating a formula from Excel into Smartsheet.

I'm in the process of recreating a payment tracker solution for some colleagues of mine, but I'm struggling to replicate one of the formulas. The formula is as follows:

=IF(DAY(C4)<=3,TEXT(C4,"yy-mm(mmm)"),TEXT(C4+30,"yy-mm(mmm)"))

The C column is referencing the date column.

The column where this formula is applied to is called "month" which advises what month the payment falls under. As you can see on the 2nd row below, even though the date is 26th April, this would fall under May's payment month.


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!