Can formulas be used in reports?
Buffie,
Not directly. As Smartsheet help puts it, "a report is a reflection of data contained in your sheets that you can edit, sort and filter based on your needs."
In this sentence "edit" means changing the values in a cell.
Some workarounds, however, can be found here:
https://community.smartsheet.com/discussion/want-sum-calculation-report-formulas-reports
Atus