Last Month Formula?
I'm trying to develop a formula for a column that lets me know if the Event date in that row is "Last Month" or not. A simple 1 or 0 result for yes or no will work. I had put together what I thought would work using Date, Year and Month, but when we hit 2023, it failed. Looking for advice.
Best Answer
Answers
-
-
Credit to @Paul Newcome for the formula found on this thread which I altered to make it work here.
-
Mike TV, works perfectly! Thanks so much!!!
-
Hello @Mike TV ! I'm curious how to get this to work when the Date column is a formula? I get an error when using this formula as "#Invalid Data Type" when referring to a date column that is populated by a formula; however, it works when a date is manually entered. Any suggestions?
-
What is the formula you're using to create the date? It sounds like the output may be seen as text instead of a date-type of value.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
But when january hits, won't this be an issue? since that month is 1 and 1 -1 =0 and month 0 does not exist.
Paul goes into detail in the thread you mention, but it concerns rolling quarter reporting.
Continuous Improvement Facilitator in HVAC industry || Timezone CES
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!