Sum from Report

Options
Sarah123
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!

Best Answer

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer βœ“
    Options

    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 GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

Answers

  • AravindGP
    AravindGP ✭✭✭✭✭✭
    Answer βœ“
    Options

    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 GP| Principal Consultant

    Atturra Data & Integration

    M: +61493337445

    E:Aravind.GP@atturra.com

    W: www.atturra.com

  • Sarah123
    Sarah123 ✭✭✭✭
    Options

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