Welcome!

Formulas

Is is possible to write a formula based on information in one sheet to put the result in a cell of another sheet?

I want to sum items if they meet certain criteria in one sheet but the result going in a cell in another sheet.

Thanks!

Formulas

Yes, it is using cross sheet formulas. Check out these articles/videos for more information:

Thank you!

Index/Distinct formula suddenly stopped working last week
I had a formula to list all distinct values from a column in another sheet. I was using this formula and it was working fine until last week. What could be wrong? =IFERROR(INDEX(DISTINCT({Liste de matériel Plage 1}); Séquence@row ); "") When I remove IFERROR, I get #INVALID DATA TYPE
Nested if functions
i have 2 columns set up one is titled INS it has four dropdowns. the other is titled AMT, the amount in the amt column is dependent on the dropdown column selection which is text.
Converting Drop-down Date to a Date formatted value
First off, I am using Control Center to build out projects that are dependent on a central worksheet, "Weeks of…" as a drop-down source list. The "Weeks of…" is contained in a Portfolio folder in the Admin workspace. Secondly, I have a worksheet, "Weeks" that contains a number of dates, DATE. In this worksheet I have an…