Hello, I'm making a form for people to fill in if they want to participate on a event. I made the form and set some dates that they can choose. The only problem is that on each date there is limited capacity. So what I would like is that when for example they choose 15/7 15 times than the date wouldn't be available anymore…
I made an inventory grid. One column has a barcode and one column has the expiration date. The expiration date reads the last 8 digits of the barcode to output a string of numbers that is the expiration date. Is it possible to make it formatted into a date like "dd/mm/yyyy". Right now it looks like this "ddmmyyyy"
Hi, I have a risk register for a project that has well over 100 risks documented and I have them categorized into 17 different risks. I would like to be able to create a formula to count how many risks exist under each category and then a formula to show the aggregate risk associated with this. I would think by a…
I have over 30 sheets (and growing daily), in a workspace. What is the quickest way to apply the same conditional formatting to every sheet?
Hi! I built a rollup sheet with the following formulas. They work, but when a row is deleted (probably added too), the formula on the reference sheet the rollup sheet causes the #INVALID REF error. I have to manually edit the formula to get it to work again. One section has about 50 rows and 3 columns of formulas.…
I am currently referencing 3 ranges off a sheet as per attachment. I have a workspace which has many sheets with the same structure. Can I reference the workspace to pick up all the same data? If so, what would be the formula?
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have no formatting and some have the grey/white formatting. Why do some have it and others do not. I cannot find a setting for…
I've been thinking about this for a while.. I would like to take the laggy and awkward pivot middle-man out of the process. I think there should be an option for sheet with a form to add the new row according to a rollup and sort. For example: the form asks for pencil color, length and quantity I enter Green, 127mm and 3 I…
I'm trying to find a way to remove inventory when an order is sold, other than manually changing the numbers. I have a form set up to add new orders to the bottom of the sheet. I need a formula to automatically remove the inventory items from each line in the Sold column. Example: Customer #1 bought 5 items of my Stock #2.…
I am wondering if there is a way to email a survey form to my group and when they each respond individually their responses fill in 1 row at a time. Example: I have 10 people in my group, they each respond to the survey and I will have 10 rows of responses. Currently, if I send the form to 2 or more users the first persons…