Formulas with reports
Options
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!
Best 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
-
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!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!