Sum from Report

Sarah123

I know this has been asked but it's been a while so maybe there's been a change 😀. Is there a way to do any of the following?

• Use data shuttle or some sort of automation to export a report to a sheet in Smartsheet or to a Google Sheet?
• Use sum formula on a sheet from a workspace? (so that I can sum all project plans within the workspace)
• Use sum formula on a sheet from a report?
• Add color to a report if a sum of a cell is over x?

Thank you!

AravindGP

Hi @Sarah123

The answer to your first three questions are a no, there isn't an option yet to do it. Adding color to a report is possible if you have conditional formats in the underlying sheet(s). You can't add formatting options from a report as yet.

AravindGP

Hi @Sarah123

The answer to your first three questions are a no, there isn't an option yet to do it. Adding color to a report is possible if you have conditional formats in the underlying sheet(s). You can't add formatting options from a report as yet.

Sarah123

Thanks @AravindGP - and yes, I was hoping to be able to setup conditional formatting based on the report summaries 😄