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

Benjo09

Hi,

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.

Benjo09

@Andrée Starå @Paul Newcome I have you read some of your advice in using INDEX/Match from some of the questions related to referencing a formula from the Report. Kindly help me with alternative solutions?

Andrée Starå

Hi @Benjo09

As a possible workaround, you could maybe export the report to Excel and then import/copy the data to a Smartsheet sheet.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Benjo09

Hi Andree,

Yes, I also see that as alternative but I was required to automate the process. I am thinking to use "copy rows" from the automation workflow and set the trigger every sunday then get the last 7 days. But the problem is, status is being updated even the week is already past.

Right now, I'm thinking to make my Metric Sheet refer directly to the "Working Sheet". Is there a direct formula of SUMIF/s or CountIF/s that can calculate a WEEKLY and Monthly value based to the "Created Date"?

Andrée Starå

@Benjo09

Yes, there is. You'd use the WEEKNUMBER AND MONTH functions combined with your SUMIF(S) / COUNTIF(S) or similar.

Would that work?