Hot take: B2B UX is the hardest design work and gets the least airtime.
Your user didn't choose your product. Their boss did. They use it 6 hours a day, can't switch, and will quietly build an Excel sheet to work around your "intuitive" flow.
Design for the Excel sheet.