Merge Add-on for Google: Formatting Options?

larryb

I'm using the Merge Add-on to generate email messages and PDF documents from my Smartsheet. 

While my sheet has many columns of dates in the MM/DD/YY format (which is good for managing the data), I'd like my documents to be in the 'monthname dd, yyyy' format.  Are there formatting codes for the merge fields, or is there another way to do this? 

 

  

Andrée Starå

Hi Larry,

Unfortunately, I don't think there is, but you could maybe format it in another column in the sheet.

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

larryb

Hi Andrée,

Thanks for the response! About formatting in another column in the sheet - I'm new to Smartsheet, but I am not able to find a way to format a date in a single column differently. It thought it was globally tied to my location settings and not customizable within a sheet?

Larry

 

Andrée Starå

Happy to help!

Try this.

The Date should be changed to the column name of the date that you want to reformat. You can change the order to get the date in the way that you want.

=MONTH(Date@row) + "/" + DAY(Date@row) + "/" + YEAR(Date@row)    

The same version but with the below changes for your and others convenience.    

=MONTH(Date@row) + "/" + DAY(Date@row) + "/" + YEAR(Date@row)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

Best,

Andrée

larryb

Ah...I haven't been thinking enough in terms of formulas. Thanks for the tip!

Larry

Andrée Starå

Happy to help!

Best,

Andrée