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.
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.
Thanks for letting me know, Heather!