I am trying to create a helper column to flag something as occuring "This Month" or "Last Month"
This is the formula I'm using.
=IF(Date@row = MONTH(TODAY()), "This Month", "Last Month")
It is saying #INVALID OPERATION. Not sure what I have wrong here.
=IF(MONTH(Date@row) = MONTH(TODAY()), "This Month", "Last Month")
You were on the right track.
Will the current and previous months be the only options? Will there be entries from prior to last month?
Is there a way to create a filter to only show let's say cells highlighted in yellow?
I'm having some issues with the workflows cos' sometimes they just stop working and once i run them again, everything works again. So, I think I may be the number of columns the Smartsheet has (about 200)
As the Owner/Creator of a User Group, my User ID is automatically included as a member in the group when I create it. This inclusion makes it easy to troubleshoot problems with Smartsheet applications created by other people in the District who use my User Groups to grant access to their app. I deleted myself in several…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.