Converting MM/YY into MM/DD/YY for date column

Jason F

Jason F ✭✭✭✭

05/03/24 edited 05/03/24 in Smartsheet Basics

I had searched on here a couple times and tried some of what I found, couldn't get it to work.

I have the date imported in MM/YY format as a text column. I'd like to have a date column next to it, with MM/DD/YY, with the DD being the last day of the calendar month.

Am I aiming too high?

Tags:

Formulas

0 ·

Categories

Trending in Smartsheet Basics

Try to capture Minimum and Maximum dates
I set up 2 columns ("Start Date" and "End Date") on a sheet. I would like to populate the heaer of the column with the minimum Start Date and the maximum End Date. But I just get the error "This Column is restricted to dates."
Changing Status Symbol from "Hold" to "Yes" depending on dropdown menu entry
Hi all! I am looking to utilize the "Hold" and "Yes" symbols (Yellow triangle with ! and Green circle with check mark) as a "health indicator" depending on a specific value recorded in a dropdown menu column. I have a dropdown menu column whereby the you can select either "E-MAIL" or "REPORT" as the value of the "Last…
How can I ensure email notifications contain ALL changes?
I have a workflow set up to trigger when a particular column is edited. Problem is that the email alert only shows the first 20 items. How can I change this limitation or build a workaround to show all changes to the stakeholders. I can't use 'time of day' trigger because I need the column change to be part of the trigger.

Help shape the future of Smartsheet.
Share your ideas and feature requests.