Sum from Report
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!
Best Answer
-
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.
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training
Answers
-
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.
Thanks,
Aravind
Reach out for any help on licenses, configuration, or training
-
Thanks @AravindGP - and yes, I was hoping to be able to setup conditional formatting based on the report summaries π