In many ways, calculated columns can *replace* work that you used to do in Google Sheets.  

For more info on the formulas available in calculated columns, check out the Google docs: