Auto Update of column like excel

System Information
  • Strapi Version:
  • Operating System:
  • Database:
  • Node Version:
  • NPM Version:
  • Yarn Version:

I’m running strapi project locally and i have created few tables. What i want to achieve is that i want to create a column who value is calculated based on another column. like column operations in excel.

kindly help me
thank you