-
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…
-
Leads and Lags / Fast-Tracking Project
Smartsheet could consider creating a formula to lock a specific cell since it is sometimes necessary to block a successor date; it is difficult to add leads and lags and not move other dates, for example, when used in projects with fast-tracking compression.
-
How to Count a value in a drop down / multi-selection list?
Hi, I'm wanting to count the total amount time this value "VAVE" is being assigned to a drop down column. I'm using a summary sheet to collect this data using formulas. So in the request type column(drop down list) I want the total in this sheet. I also want a total by the Brand. I keep getting an incorrect number, like 48…