nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Using multiple Sheets

Naweed Nayib

Hi,

How can I reference reports in a project matrix sheet using formulas such as =IF =CountIF?

Any feedback will be highly appreciated. Thanks

Find more posts tagged with

Comments

Andrée Starå

Hi Naweed,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Yeah, you can only reference sheets using cross sheet formulas. It seems like you have all the data you need to use those sheets and do your cross-referencing. Maybe one of these links will help you accomplish your goals.

Paul Newcome

I agree with Andree and Mike. It is a great idea, but it seems like you most likely have the data you need to be able to use cross sheet references in formulas.

You can build the same criteria into a COUNTIFS or a SUMIFS that you used to build a report. If a function you need doesn't contain an IF(S) version, you can always use the COLLECT function.

COUNT --> COUNTIF(S)

SUM --> SUMIF(S)

AVG --> AVG(COLLECT(

JOIN --> JOIN(COLLECT(

Sign in to join the conversation!

Quick Links

Trending discussions

Data is missing
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
Can you do a portfolio report on manually created project sheets?
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Users incorrectly labelled as "External"
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…