Help

Turn list into a checklist

Topic Labels: Formulas
2002 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jm22
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello i have a list of ingredients that are in a single long text cell

Screen Shot 2023-02-07 at 5.48.19 pm.png

Sa
Sweet potato
Carrot

I want it to put a ▢ infront of each item 

▢ Salmon
▢ Sweet potato
▢ Carrot

 

TIA

2 Replies 2
matt_stewart1
7 - App Architect
7 - App Architect

it needs to be a "Long Text" field and then you can highlight your list and click the formatting pop-up and change to "checklist". 

Screenshot 2023-02-07 at 6.23.25 AM.png

Screenshot 2023-02-07 at 6.22.59 AM.png

If you'd like to do this automated, you could check out this base  where you use a formula field to format the data, and use an automation to paste that formatted data into the long text field that has rich text formatting enabled.  (You can duplicate the base to get the formula used)

convert.gif

Using copy paste with the formula field doesn't work unfortunately