Helper column formula to identify if "Month Requested" was the previous month

Christina C
Christina C โœญโœญโœญ

Hi!

I really thought I had this one but I am getting an INCORRECT ARGUEMENT error.

I have created a help column to flag if the "month requested" value in my sheet is the Previous Month. I need to flag rows that are previous month to use in a filter for a report as I will be sending the report out the first day of the month for the previous month automatically.

Here's my formula:

=IF(MONTH([Month Requested]@row = MONTH(TODAY()) - 1, "Previous Month", ""))

If the Month Requested is the previous month I would like to see "Previous Month" returned, otherwise it would be blank.


image.png

What am I doing wrong? Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!