-
Index collect formula question
Hello I need some assistance with my index collect function, In one cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "") In another cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event],…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
-
Can you filter a sheet to view entries between two times the days prior?
I am looking to filter a sheet to show only entries made between 6AM yesterday and 6AM the day before yesterday. I tried using a helper column with the below formula to input a value that I could then use in a sheet filter to show only those rows with a value of "1" but am getting an error in return. =IF(Created@row <…
-
Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
-
Recall AI Prompt at a Later Date
Absolutely love the AI companion. However, after a formula is generated, I lose access to the prompt that was used to write the formula. If at a later date, I want to come back and alter my prompt, have to completely re-write it, risking error due to human memory lapse, especially if the prompt is long and the resulting…
-
Sort by month and year
I'm trying to summarize a sheet that has data from Sept '23 - Sept '24. I'm using this formula =COUNTIFS([Study Type]:[Study Type], "SOW", [Date Received]:[Date Received], IFERROR(MONTH(@cell ), 0) = 9) to sort by project type and month, but it's combining everything from September '23 and September '24. What can I do to…
-
Perpetual Contract Renewal Formula
Hello All! I am trying to create a formula that will automatically update the end date to a contract based on a renewal timeframe. For example, Contract Start date 12.31.19, Contract end date 12.31.20 at the end of the contract, the contract will renew for 1 year perpetually on the same date. Right now we are at 11.8.24,…
-
Formula IF OR CONTAINS - Change State to State Abbreviation
I have a State Column and a State Abbreviation Column. The State column is a dropdown column that is filled out from a Form. I have a Formula in the State Abbreviation Column that looks at the State Column and then populates the appropriate State Abbreviation. Here is my issue for West Virgina and Arkansas it populates…
-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
