Formulas with reports

05/11/21
Accepted

Hi,

I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report.


When I build the formula, the report is not an option in the list.


Please advise.


Thank you!

Popular Tags:

Best Answer

  • Heather DHeather D ✭✭✭✭✭
    Accepted Answer

    Hi @Irina Iatco ,


    Unfortunately, Smartsheet doesn't let you calculate off of data from reports. You would need to create your formulas based off of the source sheets, rather than the report.


    Best,

    Heather

Answers

  • Heather DHeather D ✭✭✭✭✭
    Accepted Answer

    Hi @Irina Iatco ,


    Unfortunately, Smartsheet doesn't let you calculate off of data from reports. You would need to create your formulas based off of the source sheets, rather than the report.


    Best,

    Heather

  • Thanks for letting me know, Heather!

Sign In or Register to comment.