NitaP
NitaP
Reactions
Discussions
- Is there a way to turn off this popup? It gets in the way.
- I am getting an Invalid value error in this formula: =(INDEX(COLLECT({Zit Zap 102621 Units Needed}, {Zit Zap 102621 Formula}, Formula@row, {Zit Zap 102621 Inv ID}, [RM Inventory ID]@row), 1)) I'm tryi…
- I have a column of checkboxes and would like to check the Parent box if any of the children boxes are checked. What's the formula to do that?
- I want to take the information highlighted in this spreadsheet: and link to it in this spreadsheet: so that if I change a value in the first spreadsheet, it will also change that value in the second o…
- In this sheet I'm monitoring the inventory of raw materials. Currently, each child row compares available stock to low stock amount and returns OK or "low". However, the parent includes the total of a…
- I've copied sheets with Sheet Summaries to other sheets. I used to be able to then edit the Sheet Summaries but no longer. My only option now is to delete. Any thoughts?
- I have a sheet with raw materials used to manufacture a product. Currently, I am looking up the raw material available units by using an INDEX MATCH formula to match the Inventory ID on this sheet to …
- Is there some way of highlighting which cells in a column contains formulas and which contain text or numerals?
- I'm trying to add Units Used of a particular Raw Material with a certain Inventory Id. I've used the formula: =SUMIF([Inventory ID]:[Inventory ID], [Inventory ID]@row, [Units Used]:[Units Used]) I am …
