-
Count formula for Multi Select AND checkbox
Hi! I am currently looking to see if there is a formula that will give me a count outcome based on 1) A certain text in a multi select drop down (language) PLUS 2) if a checkbox is ticked for that same row So I am looking for the total of number of "Specific Language Speakers" in a multi select with a checkbox ticked in…
-
How do I sed an alert to follow up with a customer 7 days after contact
I want our sales person to make a follow up with a call to our customer 7 days after first meeting. I tried workflow trigger "When a date is reached and its not working" Here is screenshoot of one of the things I tried
-
Count if text contains certain words in one column and another column is not blank
Hello! I am stumped on a formula. I am trying to count the number of times the task "Full DD" is listed in the task column the cell in the "Number Completed" column is not blank. I have this formula: =COUNTIFS((Task:Task), "Full DD")(AND([Number Completed]:[Number Completed], NOT(ISBLANK(@cell)))) but it keeps coming back…
-
Workflow to Automate Document Generation?
What's the simplest process for using "Document Generation" when a new "Form" is submitted? Does anyone have a workflow that can automate this process without the need for a "Gatekeeper" or someone manually generating the row-level document after the form is submitted? Example - We have a PDF form that requires a signature…
-
Count if Name and past date.
Hi all.. I'm at a loss here, keep getting #unparseable =COUNTIF([Assigned To]:[Assigned To], "Karl"),and([Completion date]:[Completion date], <=TODAY()) Cheers.
-
Median Aged Time
I'm trying to calculate the median time a ticket is open for (on a monthly basis, so for issues that were created in January how long were those issues open for?) Simply adding in the {Created Date}, AND(IFERROR(YEAR(@cell), 0) = 2022, IFERROR(MONTH(@cell), 0) = 1) portion leads to "incorrect argument", but otherwise it…
-
INDEX COLLECT FORMULA
Hello everyone, I'm trying to do a workaround to avoid a circular reference that is happening when doing cross sheet formulas. For that purpose I'm building up a formula that brings to a column the end date of the last activity of the project Activity Start Date End Date Activity 3 Date -Project 1 Activity 1 01/01/22…
-
Combining ISBLANK and TODAY formula for RYG Symbol Column
Hi all, I'd like to automate the Health column in my Project Plan but am not sure how to go about doing this. The Health column is a symbol column (red, yellow, green). Ideally, I'd like for it to show the red symbol if the end date is 3 days late, yellow if the end date is 2 days late, green if we're on track, and blank…
-
Index Collect + If Contains Multiple Partial Terms in Column
I am trying to write a formula to pull the employee name (Full Name) from my source sheet into my target sheet if these criteria are met: · Employment Status field in source sheet lists Active or Pending for the employee · Company field in source sheet lists Company X or is blank for the employee · Job Profile field in…
-
Check box if matching value in other sheet
Hi All, I am attempting to write a formula that would check a box if a value is present in another sheet, and I can't figure out exactly how to write it. I am thinking it would be a combination of IF, INDEX, and MATCH. I have two sheets, both of which have a column called "Protocol ID." I want to check a box if the…