Formulas with reports

Irina Iatco · 05/11/21

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 · 05/11/21

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 · 05/11/21

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 · 05/13/21

Thanks for letting me know, Heather!

Formulas with reports

Best Answer

Answers

Help Article Resources

Categories