-
How to add another calculation to an If statement and Index/Match
Hi, Hopefully this will be an easy one. My brain is going completely blank on this. I have a formula that is basically calculating/selecting one of three values based on which is not empty. It is based on the user checking the "Included" box to trigger an index/match formula to show the cost (Hourly, ,Unit or Fixed), and…
-
Column Dependencies and Formula Auditing
I wish there was a way to select a column/ cell and see all formulas and automations that reference it. Similar to Excel's "Trace Dependents" and "Trace Precedents." This could all be part of a formula auditing tool that would let you see all formulas on a sheet and which column they are in.
-
Date Formula Not Working?
I am trying to auto-populate some dates in my "Due Date" column. When a date is entered in row 5, I need row 6 to be "date" - 5 days. The formula I tried was: =[Due Date]5 - 5 But when I click enter, it just adds a " ' " to the beginning and displays the formula. Am I missing something? *Note, this is when using a date…
-
Auto-Populate Hours Column
I would like for my Hours column to auto-populate with a "1" when I put a resource name in the "Assigned To" column. I have tried the basic formula but it is not returning anything when I add in a resource to the "assigned to" column =IF(AND(ISBLANK([Assigned To]@row) = false, COUNT(CHILDREN()) > 0), Hours@row + 1,…
-
Problem with my formula,working for first part but not for the last part.
Hi, My formula works for the first 10,9 and 8 but for the others i get invalid operation. the formula is below . Time criticality is a requested go live date/ current date =IF([Time Criticality]@row <= 30, 10, IF([Time Criticality]@row <= 60, 9, IF([Time Criticality]@row <= 90, 8, =IF([Time Criticality]@row <= 120, 7,…
-
Formula to look as Multi cells to check a Box on Another Sheet.
looking for help. not even sure how to Word this. but i am looking for help on writing a formula that would check a box on another sheet if this form is filled out and a assigned work order #. so if someone was to say that Step 1 is Complete with this work order #. it would Check the Step 1 box that is in the tracker…
-
LEN ... FIND ...
Hi there! I know there is a way to do this but I keep getting an error! I have these long zoom links and want to just pull the ID number into a column. I was trying the LEN and FIND functions but not having any luck. The number is always between https://zoom.us/s/ and ?zak= The random string of characters after ?zak= is…
-
Count(Distinct(Collect Formula
I am trying to write a formula to return a count of the number of unique IDs market propject and then counted by market. From what I have been reading it seems like a count(distinct(collect formula is needed. Also, I might need a helper column on my source sheet to determine which rows are unique.
-
Troubleshooting COUNTIFS with Multiple Criteria
Hi there, I'm looking for some help with a formula. I'm trying to count the number of items labeled as "THD Resource" that are also marked as "Requested." Here’s the formula I’m using: =COUNTIFS({TBD RMT Range 3}, "THD Resource", {TBD Range 1}, "Requested") But I’m getting an #INVALID REF error. Am I missing something,…
-
How to get the count of unique values from a list of repeated unique values
I have a list of people lets say Jon Sam Rick each on of them is assigned to a colour lets say any combination of colours for something that looks something like this ( see screenshot). How can I count the number individual colours for each person. For example Jon has a combination of 5 red and 5 green so his count should…