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, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…
