-
Vlookup woes
I'm trying to do a VLOOKUP and am getting the result #NOMATCH for all entries. Essentially I want to look in the Instructor column in Sheet A, check Sheet B and find the Instructor name and return their ID number. The Instructor names are in the first column of Sheet B, like they're supposed to be, and the IDs are in the…
-
CountIFs with FIND
Below formula is showing incorrect argument set. =COUNTIFS(Name3:Name356, "", [Position Title]3:[Position Title]356, "Billing Specialist", [Req Status]3:[Req Status]356, "Open", [Dept Name & Cost Center]3:[Dept Name & Cost Center]355, FIND("10", @cell) > 0) Tying to count rows that is blank in the Name column, with…
-
Additional workflow/automation actions
Scenario: In our project, we have a weekly reporting cycle. In some of our sheets, we have a field that is "previous status" or "previous actions" or other similar ones, you get the idea. Desired action: have an automated flow where, once the end of the cycle is reached (any configurable date, friday evening for example),…
-
Feature Request: Programmatically access parent information from child in automated messages
A lot of the users consuming my automated alerts complain that the tasks don't have enough contextual information. For instance, "start marketing research" doesn't include the parent information of "Awesome Campaign #3". Need a way to include parent information in automated messages. For example, "Hi {{Assigned To}}! The…
-
Best Formula
I have a construction schedule with start and finish dates. I want the check boxes for the at risk column to automatically check off if the project is late starting or late finishing. Can anyone help me craft the appropriate formula for this? Is there a good formula for this? I was thinking it would be an if then formula…
-
VLookup - Multiple Searching Criteria
Hi all, I am struggling to find a way that allows Vlookup to search with multiple criteria in two columns. Referring to the screenshots - On the worklist sheet my aim is to VLookup into the Forms Testing Sheet and the criteria be both the agent name (Row two on the Worklist) and The Week Numbers above (Row one on the…
-
Automate [Actual Finish] based on when [% Complete] reaches 100%
I can't trust taskees to update [Actual Finish] reliably, so automation seems to be the key. I want to automate [Actual Finish] based on when [% Complete] reaches 100% I have really tried to bang my head through this, but to no avail. I keep running into endless updates of [Actual Finish] or #CIRCULAR REFERENCE issues.…
-
Countifs with AND/OR
Hi There I have a Countifs that is counting the number of projects that are healthy (Green), marked as "prioritized", are "in progress" and match a particular category. This works great, except I'm trying to expand this to look for "in progress" projects OR "not started" projects, but maintain all the other AND criteria..…
-
If statement % complete column
I want to create an if statement in my % complete column such that % complete goes to 100% when another column has a date.
-
IF and OR Formula
Hi, I am trying to write a formula that returns a flag if one of column 1,2,3,4,5,6,7 isn't checked. I have tried using the IF and OR formula together but am getting #Unparseable. Any ideas/help will be appreciated. Thanks