-
Formula that combine names that falls into the selected dates
Hi, I have a sheet on which employee will submit their PTO request. The column "Team PTO" shows who else is having PTO during their requested dates within their department. Here's the formula: =JOIN(DISTINCT(COLLECT(Employee:Employee, [PTO Start Date]:[PTO Start Date], >=[PTO Start Date]@row, [PTO End Date]:[PTO End Date],…
-
How to identify if Contact -OR- Text is in a Contact column?
Hi everyone - We have starter task templates that we use when we initiate certain types of work. The templates have a Contact List column that is initially populated with ROLES (e.g. project manager, designer, tester, etc). The ROLES are then populated by the project team with the actual CONTACT names, based on the team…
-
Formula to check a parent checkbox when any child is complete & formula to complete a parent status
Hi, I need help on two formulas. Formula 1: I need the parent box to be checked any time a child task is checked. So when any of the child tasks on TestAccount are checked in "test needed", I want the TestAccount parent checkbox to be checked so I can then copy all checked parents and children to a new sheet. Formula 2: I…
-
Count rows based on 2 criteria?
Hello: I'm missing something here and I need your help. REQUIREMENT: - I need to have a formula that counts how many records on my sheet are both "LOW" (on the Priority Column) and "Closed" (On the Status Column) I've tried with COUNTIF, COUNTIFS, AND, OR....and Can't figure it out. Any pointers anyone can give me?
-
Issues With Extra Commas When Joining Values of Multiple Columns Into One
Hello, I am using the following formula to take values within multiple columns into one column: =IF(ISBLANK([Automation (Corelab)]@row), "", [Automation (Corelab)]@row + ", ") + IF(ISBLANK([Cardiometabolic (Corelab)]@row), "", [Cardiometabolic (Corelab)]@row + ", ") + IF(ISBLANK([Coagulation, Hematology, Urinanalysis…
-
Concatenate Formula; IFERROR / ISBLANK = To pull all dates where the date columns are not blank
Hi All, I'm stuck on working on a concatenate formula that pulls out all filled in date columns only. Currently unsure how to integrate IFERROR and ISBLANK functions in this formula to pull out only the date columns that are not blank! Would like some assistance on this :) Thanks, Andrei
-
Excluding Weekends from Date formulas?
Hi, I'm hoping this is possible and someone can guide me, but I am trying to automatically exclude weekends from date formulas. In my sheet I have a duration column (which is calculated based on a number of other columns: task performed, difficulty level of task, etc) and then a start/end date column which calculates on…
-
Formular: Only two requests each department per week
Hi Community, I have a sheet request form that capture transport requests from each department. Heres my scenerio: For my organsiation a request for transport is allowed only 2 request per week for each department. Requests more than two is automatically cancelled for the department. what formula can I use to a helper…
-
Need to identify who responded in the survey
I have two sheets. Sheet A is the master list of the names while Sheet B is the list of the respondents of the survey form both containing the unique identifier code. I need to identify who has and has not yet responded to the Smartsheet form. Questions: Is there a way to automatically mark Sheet A when a person submits…