I'm attempting to calculate the percentage of work that's done, round it to a whole number, and add a percent sign. I can get 2 of any 3, but not all three. =SUM(([Points Done]@row / [Total Points]@ro…
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 c…
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 expirati…
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 risk…
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 …
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, …
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 …
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 a…