-
Complex Automation
Hello! I am having trouble creating the automation to do the following: IF anything changes on a row, send to {{Contact}} for an APPROVAL. Once it is approved and the {{Status}} is Freeze, Active, or Suspended, send an UPDATE Request to {{Contact}}. See attached. It seems simple but the condition of approval logic is…
-
Check box formula
How do I create a formula that will autofill date when checkbox is checked?
-
Check if today is in between the date in two cells
I am trying to get a formula to return a specific value if today is in between the date of two cells in a sheet, but I'm getting an #UNPARSEABLE error. This is the formula I am using: =IF(AND(TODAY() > [Temp Move 1 Move In Date]@row, TODAY() <= [Temp Move 1 Move Out Date]@row), "Temp Move 1", "Not Temp Move 1")) The column…
-
Nesting INDEX/MATCH
Here's a pretty version of the formula I'm trying to implement: I can nest two INDEX/MATCHs and it works fine: =IFERROR(IFERROR(INDEX({CA Region Review Range 1}, MATCH([RE Store # Lookup]@row, {CA Region Review Range 2}, 0)), INDEX({Carolinas Region Review Range 1}, MATCH([RE Store # Lookup]@row, {Carolinas Region Review…
-
Need help with a formula
I need to be able to track when an employee needs a certificate of disability. A COD is required on the 4th sick occurrence recorded. An occurrence is defined as either 1 day OR 1 set of days that are consecutive. For example if I call off Mon-Wed, that is one occurrence. But if I call off Monday, come back Tuesday, and…
-
Auto Date Calculation/Auto Fill Date
Hello, I would like the "Referral Bonus Payout Date" to return a date that is 90 days out from today once the "Referral Bonus Amount" and "Referred By" fields are filled in. Is it possible? Please advise. Thank you!
-
VLOOKUP question
Hi everyone, I have two sheets, the first picture shows the columns in my sheet. It is a large table. Their are only 16 Superintendents, but over 1,000 principals. The second picture is my second sheet, I use this in card view. The idea is that we search a school and poof the super/principal and other contact info appear.…
-
Automate checking a box if date column is less than 2 weeks?
I have a check box column (can be changed to symbol if needed), and Id like the box to check if the date in another column is less than 2 weeks from the current date. What would the formula be? Thank you!
-
Hi, i'm trying to do a simple COUNTIF for one column, to see how many of each group exist
I'm trying to pull how many of each group are listed in the column Current Owner, and keep returning a message of #blocked. =COUNTIFS([Current Owner]:[Current Owner], "PDT", "Team Healy") Thoughts?
-
IF(AND) Function - INCORRECT ARGUMENT
I am trying to enter a value in a column based on the data in other columns. This first part of the formula works just fine. I am basically comparing the value in one field to a value in a helper cell. THIS PART WORKS: =IF(AND([Surg Cogn Comp (copy)]@row < [Helper Value]5, [Surg Perf Comp (copy)]@row < [Helper Value]6),…