Hello! I am creating a sheet that will house projects that need to be prioritized by date. Although I can sort them myself and number them, is there a way to auto number a column based on the date col…
Hello! I am looking for some assistance on a formula. I have a Master Sheet and a Helper Sheet. I am trying to calculate the number of specific events associated with a person within a date range util…
Hi - I'm trying to use an Index/Collect formula to bring back information based upon two text variables that could be included in my search range. Below is the formula as I have written it and I get a…
Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific cust…
Hi, I am trying to calculate % complete with an IF formula because if it is marked complete I want it to say 100% and the current formula is tell me it is 3,098% complete because start and end date ar…
Hello everyone, I hope you're doing well. I'm facing a difficulty in setting up automation. In the project model we've adopted, one person is responsible for monitoring the project progress, and this …
I have a check box that if checked I want my cell to be 0, but if it is not checked I would like it to sum up three other cells. What is wrong with my formula (Example #1)? I am also having an issue w…
I am trying to count how many items in a multi-select drop down column fit the criteria to accurately return the number. My main issues are that the multi select columns have multiple criteria that ne…
How do I set up a formula so that if([column A]@row="something", copy the value in [Column B]@row to [Column C]@row,""). I appreciate any help you can offer.
HI I am trying to calculate how much we have billed out, but not yet collected. We have 4 columns for each payment, up to 12 payments total. I want to add the Payment amounts together, only if Payment…
