-
I need to match a user ID in imported file to a name in a users list
I am running a zap to import new members into our client list and when the name imports, it doesn't pull the members account manager (a user in our CRM assigned to the member), instead it pulls the user ID. I would like to be able to match that user ID to the actual user. I know I can do this manually, but I would likeโฆ
-
Problem With Counting a row of data - Equation help
Hi Community, I am running into an issue with my equations when doing a count. I have a set of %complete that is being updated each week that I then am using equations to create a binary count. The Not started equation(Above) seems to be working correctly. The In Progress equation (Above) is what I am having difficultyโฆ
-
Multiple Check Boxes - Pre-Fix, joining values based on multiple check boxes.
What would be the best formula to join "text" from multiple check boxes if values are true or false? I would like to populate, the in the grey column, the values of each check box if any are true with a "text value" of the name of the check box column. I have several grey columns that will be used in with join/collect onโฆ
-
DATES FORMULA
I'm trying to create a formula for the below information: find if in a range of start dates and end dates of a specific job, one or more of these dates correspond to the current week date if that's happen the guy is not available otherwise is available for this week thanks
-
Sumif one of criteria is met - or countif?
I have a column of data that I would like to Sum if different criteria are met - here is an example - Sumif = x or y or z Sumif = a or b or c I'm trying to Sum or count Tried a few formulas so far =SUMIFS({INT/EXD - Stage}, "Not Started", or [{INT/EXD - Stage}, "IDD Started", or {INT/EXD - Stage}, "As - Is Documentationโฆ
-
How do I Count the rows on a "Contact List" column, for the current user?
Example: I list team members in a Contact List by project. Team members range from 0 to 5 team members: Goal: count each team member's occurrences on 3 projects. Art Jones, Janice Doe, Terry Tonsil, Mary Green. Project Team Members (Contact list) Market Art Jones, Janice Doe. Inventory Terry Tonsil, Janice Doe, Mary Green.โฆ
-
I need a formula to return a value in column B, if column A has some random number.
In the below example: Column A has some random numbers and i need a value "Test" to be displayed, if column A has a number, otherwise it should be blank incase if there is no value in Column A. I need a formula to create this.
-
I need a formula to return a value in column B, if column A has some random number.
In the below example: Column A has some random numbers and i need a value "Test" to be displayed, if column A has a number, otherwise it should be blank incase if there is no value in Column A.
-
Formula
I need assistance with a formula. I need to track the number of remaining business days until a project "Due Date," but once a "Completion Date" has been entered, I want that number of days to stop counting so that I can see how many days the project was over due. This is what I have so far: =IF(Status@row = "Complete",โฆ
-
Pull In Managers Manager (rows are not using hierarchy)
Hello, Community! I could use some help with a formula. If Worker or Manager were using hierarchy, it seems like it would be more straightforward. So, what I'm trying to accomplish is a formula to pull in the Managers' Manager. In the below example, the person in Manager is the VP, the name in Worker is under him (so 01โฆ