is there a way to have a single record which contains multiple fields appear on two rows of a saved search? I want Record 1 to appear with Field 1 on line 1 and Field 2 on line 2, both fields appearing in a single field/column of the results

AI generated answer (using internal Slack threads):

Based on the conversations, it seems that you can achieve this by using a formula in your saved search. You can use the

||

operator to concatenate the fields you want to appear in a single column. Here's an example of how you can do this: 1. Go to your saved search and add a new column. 2. In the new column, select

Formula (Text)

as the type. 3. In the formula field, enter

{Field1} || ' ' || {Field2}

. Replace

Field1

and

Field2

with the actual field IDs you want to combine. The

' '

is a space character that separates the values of the two fields. 4. Save your changes. This will result in a single column with the values of

Field1

and

Field2

separated by a space. Each record will appear on its own row in the saved search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******