Formulas and Functions
Archives for April 2022
Discussion List
-
Pulling Column Info Based on Column Containing Data in Separate SheetIn Formulas and FunctionsI am trying to figure out how to pull in the Name, County and Status from a master list onto a new sheet based on the master's Status column containing data. I am wanting to do this so that we are not overlooking anyone. I have been tryi…
-
Formula to assign a contact on all rows of main parent cellIn Formulas and FunctionsHello! I want to assign all rows under the main parent cell (has multiple sub parent cells within) the contact that we inputted into the main parent row. When tasks are added within the project, I want it to auto assign that row. Can anyon…Answered - Pending Review 11 views 2 comments 0 points Most recent by Kelly Drake Formulas and Functions
-
Count based on two criteriaIn Formulas and FunctionsHi, This is just an example below. I am trying to get a formula for the 'count' column. I want to return a number from 'dates' and 'group'. If there are two of the same dates with the same group, I want a '2' in that cell. If there is only…
-
Formula to convert date (e.g., 03/13/22) to text/number field (03/13/22) in same sheet?In Formulas and FunctionsA sheet that has a Dynamic View includes a date field (Start Date) that Dynamic Viewers need to use as a filter. Since users cannot filter by date fields in Dynamic View, I've added a helper column (text/number) in the sheet but cannot fin…
-
If Formula UnparsableIn Formulas and FunctionsWould anyone be able to help see what's wrong with this formula? I'm not sure how I'm screwing this up.. My formula works like this but if the status is anything other than partial I'd like the cell to say "N/A" =IF([email protected] =…
-
What formula can I use to identify blank columns?In Formulas and FunctionsI'd like my column to call out "missing fields" if someone fails to input information to all columns of the spreadsheet. Here is the formula I have in place but I am getting an error. =IF(ISBLANK([Partner Name]1):([Tracking Metho…Answered - Pending Review 31 views 3 comments 0 points Most recent by Kevin Smith Formulas and Functions
-
Fix my FormulaIn Formulas and FunctionsCan someone please tell me what I'm missing here? I'm trying to count the number of records where "Stage 1" finish date is in the past and "Stage 2" finish date is in the future. I'm not getting any syntax errors and e…Answered - Pending Review 31 views 16 comments 0 points Most recent by Kelly Gabel Formulas and Functions
-
JOIN function for child rowIn Formulas and FunctionsHi everyone, I'm currently working on a way to leverage formulas and row hierarches to create a ROW ID column. Essentially what I would like to happen for children rows to have the same "item ID" as their ancestorial row. This i…Answered - Pending Review 13 views 2 comments 0 points Most recent by nlarson_PMC Formulas and Functions
-
Can you lock comments so that those with certain permissions cannot see them?In Formulas and FunctionsI know you can lock rows and columns, but can you lock certain comments so that those with certain access levels cannot see what is in the comments? For example, we are giving view only access to certain people on a stakeholder list, but…
-
Trying to apply conditional assignments to a column based on either a formula or VLOOKUPIn Formulas and FunctionsThere must be something I'm missing. t seems like either of the following approaches should work but don't. I'm trying to auto assign a value within a specified column ("Power User") based on the values captured in two other colu…Answered - Pending Review 13 views 3 comments 0 points Most recent by MrRighty Formulas and Functions