-
Removing Duplicates from a Report
Hello, I have a sheet with many line items, some of which share some columns that have duplicitous information. I would like to pull a report from that sheet to display certain information on a dashboard and, ideally, within the report, run a conditional format to remove the duplicate line items. I am also reading up on…
-
Help with Formula
Hi Community, I am trying to calculate a formula that references a date column 1 (Start Date), and a date column 2 (transfer Date) and chooses the date column that is greater, if there is no date column 2(transfer) present then it defers the date column 2. Any assistance is greatly appreciated Thank you,
-
Counting only weekdays Formula?
Hello, I have a ticket tracker where it counts how many days a ticket has been open. Currently it includes weekends and i don't need it to. Is there a way or formula to count the amount of days a ticket has been open excluding weekends? I have a date created column and then a date closed column and use this formula current…
-
COUNTIFS/CONTAINS FUNCTION
Hi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, "In Progress", {CORP ADMIN TEAM TASKS Range 2}, "Jane Doe") However, it is only…
-
Cross Sheet Countifs multiple columns
I’ve built out an Error Tracking Mastersheet and I’m now trying to roll the metrics up but I’m struggling a bit. There are 4 types of errors that can be made (DE, CE, LE, EE). There are close to 20 people, but for the example below I only show 3. Each person is their own Drop down column with the same 4 error types. Each…
-
COUNTIFS Function of # of Values Used in a Median Calculation for Metric Sheet
I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1))) I now want to calculate in a adjacent column the total…
-
Index/Match Cross Sheet References Broken after Control Center Provisioning
I'm having issues with Index/Match formulas to external sheet being broken on new sheet created through provisioning in Control Center? I have a different blueprint set up in Control Center that contains an Index/Match formula to an external sheet that works as intended and I can't figure out what is different The external…
-
Parent Child formula for Checkboxes
Hello, I am working on a checkbox column formula for a sheet that will function as a roll up but will not automatically check the lowest children. Currently I have this: =IF(COUNTIFS(CHILDREN(), 1) = COUNT(CHILDREN(Tasks@row)), 1) That formula works, but you have to manually add it to each parent row. I would rather have…
-
NetworkDays with IF functionality
Hi, I am trying to gather a sum total headcount for each day of the month based off another sheet that has a date range of each users visit. How do i capture the total headcount for each day a user is onsite? I have been using IF(NETWORKDAYS( START DATE, END DATE, = specific day) and get an incorrect argument error.…
-
=COUNTIFS Function does not appear to work
Hi all, I am new to Smartsheets and would appreciate a little help. I have a sheet with a list of UAT defect reports within it and I am using a separate sheet to try to calculate various statistics. When trying to calculate how may defect reports are open for an individual I have used the following formula: =COUNTIFS({UAT…