Formulas with reports

Irina Iatco

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!

Heather Duff

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

Heather Duff

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

Irina Iatco

Thanks for letting me know, Heather!