formula (text) to show the items that a transactio...
# ask-stanley-ai
n
formula (text) to show the items that a transaction includes in a summary saved search on one row
c
AI generated answer (using internal Slack threads):
To show the items that a transaction includes in a summary saved search on one row, you can use the
NS_CONCAT
function in a formula (text) field. This function is not listed in the function list, but it can be used to concatenate a list of items. Here is how you can do it: 1. In your saved search, go to the Results tab. 2. Add a new line with the following settings: - Summary Type: Minimum - Field: Formula (Text) - Formula:
NS_CONCAT({item})
3. Make sure all other columns in your search are set to a summary type of 'Group'. This will create a new column in your saved search results that includes a comma-separated list of all items included in each transaction. Please note that the
NS_CONCAT
function will only work if the search is a summary search, and all other fields are set to 'Group' in the summary type. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.840975881
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.8385005
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.837126553
Please provide your feedback on this answer.