view a previous "Formula (Date" formula in highlighting tab in saved search

AI generated answer (using internal Slack threads):

To view a previous "Formula (Date)" formula in the highlighting tab in a saved search, you would need to navigate to the saved search in question and go to the "Highlighting" tab. Here, you can see any existing formulas that have been set up for highlighting specific data in the search results. If you want to highlight a specific value in red, you would need to use a "Formula (Text)" in the "Highlight If" section. For example, if you have a product that you want to highlight, you could use a formula like

CASE WHEN {item} = 'YourSpecificProduct' THEN 1 ELSE 0 END

. This would return 1 (true) for your specific product and 0 (false) for all other products. You can then set the text color to red for rows where this formula is true. To sort the saved search to show highlighted fields on top, you can create a custom formula with the highlighted rows having a higher (or lower) value than the non-highlighted rows and then sort by that formula. For example, you could create a formula like

CASE WHEN {item} = 'YourSpecificProduct' THEN 1 ELSE 0 END

and sort by this formula. This would give a higher value to rows with your specific product and thus they would appear on top when sorted in descending order. Please note that these are just examples and you would need to adjust the formulas to fit your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******