Is there a way or alternative way in referencing a formula from the Report?



I have a huge data in my sheet which is automatically fetching data from a google sheet. And to summarize my data to which I need, I am planning to use a Report but when I am computing for a COUNTIF, I have realized that the we can't reference a formula from the Report yet.

Is there a new feature to convert Report into sheet? If no, how you managed to do it? Any alternate way?

I have read that Index/Match can be use but I don't know how to do it.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!