Dropping day from date format
Hi Smartsheet Community,
I need to report a date field in a report, however the client only wants to report mm-yyyy instead of the full date (dd-mm-yy).
For example, in the fields below they want to report 09/2020 and 04/2021, and 08/2020 and 08/2020 respectively
Is there anyway to drop the day component in another column which I can use for the report?
Help Article Resources
Check out the Formula Handbook template!