Variable bullet lists

[Kevin M]

Looking to create a bullet list in a mail merge that may have up to 4 bullets.  e.g.

• <<P1>>
• <<P2>>
• <<P3>>
• <<P4>>

If there rows with less than 4 values in the spreadsheet would not like to create the extra blank bullets

Possible?

[Mark Damon]

I might be overthinking it, but the ASCII code for a bullet is ALT+254.  I would go into my google sheet and enter insert a colum and put the bullet in a cell.  Then, I would create columns for the responses that are if/then statement… if there is data, then concatenate the bullet and the entered item.  However, if there is no data, leave the cell blank.

 

The concatenate cell would look like this… =if(A2=””,””,concatenate (E2,A2)   where A2 houses the data and E2 is the bullet.  Then, if there is any null values, it would remain blank.  Then, have autocrat pull the columns that contain the concatenated items.

 

 

Mark E. Damon
Educational Technology Coordinator
Google Certified Trainer
Medford Township School District
137 Hartford Road
Medford, New Jersey  08055

 

Website:  http://bit.ly/EdTechCoordinator

 

From: nv-autocr...@googlegroups.com <nv-autocr...@googlegroups.com> On Behalf Of Kevin M
Sent: Wednesday, May 22, 2019 6:50 PM
To: NV Autocrat Add-on <nv-autocr...@googlegroups.com>
Subject: [Autocrat Google Group] Variable bullet lists

 

CAUTION: This email originated from outside of Medford School District, use caution when opening links, attachments, or providing information.

 

--
You received this message because you are subscribed to the Google Groups "NV Autocrat Add-on" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nv-autocrat-add...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/nv-autocrat-add-on/e33af427-0c52-4938-acf1-16076590c9df%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.