-
Index/match not working and I can see be reason why!
I am index/ matching from another sheet and it says no match, but there is clearly a match! I have moved the information into the same sheet to see if it would pick it up and it does but only some rows. I don't get it!
-
Add years to a date
Hi, I'm trying to populate a column with a future date. What formula can I use to take a birthdate entry in one column and add 26 years? Seems like a simple enough ask, but nothing I've seen in other questions seems like a plug & play answer to me. Both columns are date field settings Thanks!
-
Dynamic Formula Change to Date Function
Hello, I have a list of "Created Dates" and I'm trying to pull the appropriate "Created Date" into each Week and under its Day of the Week in a more efficient way. So far I have used "=COUNTIF([Created Date]:[Created Date], =DATE(2020, 3, 1))" to find 1 item for the Week of 3/1/2020 on Sunday specifically. As well as using…
-
How to set a column true if parent row
I need to set a helper column with a value for parent rows so I can use those rows in a report. I have tried the Parent() function, but I dont think its exactly what I need. Not really understanding what it returns. In the report I need to filter out children and show only parent rows. Can someone give a hand? Thanks Pam
-
Auto-assign contact based on department within a form
Hello! I have a form for project intake work where the end user has the option to specify in which department they feel their project should reside (for example, DBA versus Phones/Communications, etc.). I'd love to use INDEX/MATCH to auto-assign a PM based on what that department is e.g., DBA = Johnny Appleseed,…
-
Conditional formatting on rows
Is there a way to set up a formula for the following scenario: If I check a checkbox in column 1 on row 1, i want to send an update request to the contact in row 2 to review the attachment in row 2?
-
Check off parent row when all children are checked
Hi, I'm trying to type a formula that will check off the parent row, once all the children are checked off. I found the below formula in a different community post, however it's not working. Perhaps because the children are not in the primary column but in a different one? =IF(COUNT(CHILDREN([Resident Name]2) =…
-
Why is my COUNTIFS formula counting more items than necessary?
Hi all! I'm currently using the following formula (with references) to count the amount of items that fit a certain criteria (91-180 days, 181-270 days, and >270 days): =COUNTIFS({Age Grouping}, "desired amount of days") The formula works perfectly for the first two criteria, however, when it counts ">270 days", it returns…
-
adding dates to numeric value to obtain another date
I want to add a date numeric value in another field. example [date]1 + [days]1 = date Where "Date" equals 7/1/2020 and "days" 30 with the final date equal to 7/31/2020. The expectation is instead of having hard and fast dates to work with, to create a timeframe of when work will begin and the estimated time for completion.…
-
Cell Referencing
Hello, I have a formula that I want to drag down a column but I run into issues where after I drag down the formula, I will have to update the reference column. It's time consuming if I have 50 columns.