Mark_Werner - profile

Mark_Werner · Jun 23, 2022

I am creating standard project tasks from a template and am stuck with writing a formula that creates a comma-separated text string from the names of linked records but also adds the project name to the front of each record name in order to make it a...

Mark_Werner · Jun 23, 2022

augmented: SUBSTITUTE(Project & '-' & Tasks, ',', ',' & Project & '-') Thank you so much! That worked PERFECTLY! Yes, “Cat”, “Dog”, and “Cow” are generic records in another table (they are a template that is applied to all projects). Only prob...

Mark_Werner · Jun 23, 2022

@Adam_TheTimeSavingCo please share the formula you used to create the unique list from the linked Task names Update: I used: SUBSTITUTE({Linked Tasks} & ’ (’ & {Project Name}&‘)’, ‘,’,’ (’ & {Project Name} & ‘)’& ‘,’)

User Statistics

User Activity

Convert linked record names into unique comma separated values

Re: Convert linked record names into unique comma separated values

Re: Create tasks from templates table via button automatically