Sign in to join the conversation:
Is possible to declare one custom date format for a column and another format for another column using smartsheets?
by the way I would like to see the birthdays as mmm - dd instead mm/dd/yyyy
Hi,
If you click on the icon on the far right in the toolbar, you can change the date format.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I would also like to know if it's possible to format a date in a custom format, say only as YYYY, which is not available as one of the options currently.
Hi Amarjyoti,
Unfortunately, it's not possible at the moment, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment
I hope that helps!
Workflow Consultant / CEO @ WORK BOLD
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
@Amarjyoti Dutta While there is not a built in format for YYYY, you can use the formula of
=YEAR([Date Column]@row)
to generate the 4 digit year.
Hi All, We have several update automations on various solutions - and have worked very well for getting info from people that dont have smartsheet access - how ever in Sept we switched over to SSO and MFA and activated the Safe Share - We have now run into an issue that when our update automations trigger and people within…
I am trying to send non-Smartsheets users information on forms. I know I can create a publicly accessible and editable link for the overall sheet/form, however, when I set up automated emails with links to the forms, the links to sheets/rows still require a login. Is there any way to get around it so that emails sent…
This discussion was created from comments split from: Generate documents from row data.
