Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. …
Hello! I don't yet see this question put out there, so here we go: I have a column that has both negative and positive values. I would like to create a formula that counts how many negative values exi…
For example, in column A I have the date 1/22/23. Now in column B I want it to automatically calculate 2/22/23. I know how to add 30 days to a date in a formula but since not all months have 30 days I…
Hello, I have two sheets, the blue one is (Sheet 1) and the yellow one is (Sheet 2). Sheet 1 are data that I got from a form, which includes the date schedule slot and timing. Now, I want in Sheet 2 t…
Hi all, I need to add a formula to a sheet that will create 120 rows for the same date for all days in 2024. For example, 1/1/24 will have 120 rows, then 1/2/24 will have 120 rows and so on. Is this p…
I've built a sheet that calculates the days since last event. I display this on a dashboard in chart form. However, I don't want the days to just keep increasing indefinitely. Is there a formula or a …
Hello, I'm looking to have a formula to display the next/upcoming date in the list. The formula is on another sheet (Sheet = "Helper Calculations"), so I need to reference another sheet (the one in th…
Hi :) I am using this formula to calculate the days between when an action was Requested and when it was Completed, with an extra bit on the end to add the word "days" to the count result. =[Completed…
I have child rows that use a formula to calculate % completion based on input to another column. I'd like the parent row to return a value based on the child values (Specifically, sum of the child row…
This seems like such an elementary question but I keep going around and around on this and I can't find what I'm doing wrong. I'm trying to count the number of parent rows in the sheet (each parent ro…
