Help with Date Formula
I am generating an alert that will send based off a date that I'm creating in a field. It will be the combination of Today's Year, a month that's calculated as the "month before a renewal date", and the day will be the 2nd of the month.
I have researched enough to see that I need to use the DATE function in order to have Smartsheet view the data as a date (and not just numbers/text). I am having success using [_Today's Year]@row but when I try to pull in [_Month of Reminder}@row, I'm getting an invalid data type error message.
Would someone mind taking a look to see if you can find where I'm going wrong?
Here's the current formula:
Here's my error message:
And here's the calculation for how I'm getting to the _Month of Reminder:
Thanks in advance for any help you can provide!
Help Article Resources
Check out the Formula Handbook template!