Hello,

I am trying to create a formula in my NetSuite saved search but I am not too comfortable with creating formulas, can anyone assist?

Scenario: Price Update Search

I would like to have the lines highlighted for this scenario,

If customer has multiple end date for the same Item highlight the row(s)/line(s)

Customer field - custrecord_edp_update_customer

End Date field - custrecord_edp_update_end_date

In the picture above I show that there is a Item setup for a price update and although the start dates are not the same the end dates are which is causing an issue. I do not believe the system should have allowed the price update in December to be created as the one that started in September is still active but nonetheless I would like to see if I can get a formula to highlight these rows when this issue occurrs.