Formulas and Reports

edited 12/09/19 in Smartsheet Basics

Hello everyone

This may be a simple fix; however, I am fairly new to Smartsheet and any insight would be appreciated. I built a report that is linked to three different sheets. They were originally imported from Excel that way the formulas would carry over easily. When I pulled everything together, the three rows that I needed (the totals rows at the bottom of each imported sheet) did not carry over. I thought maybe because they were formulas, they were not transferring properly, but 95% of my cells are formula based. It is just the SUM rows that are excluded and I am not sure why. The "SUM" rows use the same formulas as every other row. The only big difference is that the font color and fill are different. Any suggestions as to why this is happening?