Formulas and Reports

tye.gardner35371

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? 

 

Thanks, 

Mike Wilday

I wonder if you have conditional formatting set up on your sheet. Where those rows exist? 

Check the conditional format button on the Left Side of the User Interface. 

Andrée Starå

Hi Tye,

Can you share the sheets or take screenshots of both the Excel and Smartsheet sheet?

Best,

Andrée Starå - Workflow Consultant / Get Done

tye.gardner35371

I checked and I do not, I will be posting a screen shot of what I have. 

tye.gardner35371

I can only share a limited amount of information, I hope this is enough. What do you specifically need to see? 

tye.gardner35371

Top is Excel and bottom is Smartsheet 

Mike Wilday

Have you tried selecting the row and setting the row color and text color to defaults? 

tye.gardner35371

Yeah I sure did, the only thing I can come up with is that Smartsheet is having a problem with the formulas. My goal would to have 3 different sum/total rows, and I don't think it is working well with that.

Mike Wilday

I would contact support and have them walk through the sheet with you and help identify what the issue is. Please let us know what the issue was once you get it straightened out. 

Andrée Starå

Hi again Tye,

Just so i understand this correctly.

The Excel sheets that you import doesn't include the last three rows?

Can you share a screenshot of those three rows?

Best,

Andrée

Mike Wilday

Can you send us a screenshot of your report filter settings? Its possible that something in your report settings are preventing one of the rows from appearing.

tye.gardner35371

I figured the problem out. Each rows primary key (I think it is called), was assigned to a job number. Ex. 17-567. The total row, at the bottoms of each sheet, did not have a job number applied to it. So, I had to make up a random job number for the total row for it to transfer over correctly.

 

Thank you for your assistance!

Mike Wilday

AHHHHHH...  Yeah, your report filter was probably looking for that number. Good catch. 

Andrée Starå

Glad to hear that you found what was causing the issue.

Best,

Andrée