-
Adding Overall % and Date Questions
I am using the Project Manager Office Template from Smartsheet. I would like to have the very top row (it is almost like a summary row), calculate the overall % complete of the project and adjust the start and end dates as the schedule changes/ progresses. I tried adding a formula to both sections but it would not actually…
-
SUMIFS with CONTAINS
Hello, I want to write a formula that SUMS charges ("Ext Price" column) from all item descriptions that contain a word ("CF") from an accounting "Activity Description" column. I've tried various versions of this. =SUMIFS(CONTAINS({Activity Description}, "CF", {Ext Price}) =SUMIFS({Activity Description}, CONTAINS(CF), {Ext…
-
Using SUMIFS Formula
Needing help writing a SUMIFS formula! I have tried a few ways, but just get errors. =SUMIFS({budget}, {Type}, "AMR", {leadership}, "Truttmann")) I would like to have the sum of the budget if the type is AMR and the leadership is Truttmann. I have multiple types and leaderships that I would be using this for. Thanks!
-
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
