Feb 07, 2023 01:49 AM
Hello i have a list of ingredients that are in a single long text cell
Sa
Sweet potato
Carrot
I want it to put a ▢ infront of each item
▢ Salmon
▢ Sweet potato
▢ Carrot
TIA
Feb 07, 2023 05:24 AM
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".
Feb 07, 2023 06:51 AM
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)
Using copy paste with the formula field doesn't work unfortunately