formula to show header ship date in a sales order saved search when the main line is false

AI generated answer (using internal Slack threads):

To show the header ship date in a sales order saved search when the main line is false, you can use a formula field. Here is the formula you can use:

formula (date) = MIN ({shipdate}) over(partition by {internalid} ORDER BY {line} ASC)

This formula will partition the data by the internal id of the sales order and order it by the line number. It will then return the minimum ship date, which should be the header ship date. Please note that you need to add this formula in the 'Results' tab of the saved search under 'Summary Type' select 'Minimum' and under 'Field' select 'Formula (Date)'. Then paste the formula in the 'Formula*' box. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******