-
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…
-
COUNTIF referencing another sheet and based on weight - can't get it to work
Hello, I am working on a capacity worksheet for my team. Essentially I am taking information from 8 different backlogs to calculate how much work has been assigned to them and comparing that against their capacity so we are able to see if they are under/over/correctly allocated. What I am trying to do is from my Capacity…
-
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…
-
Help on creating a metrics formula in smartsheet with a date range and text crteria (2 column ranges
Could someone help me with my formula below, I am not sure what I am doing wrong... =COUNTIFS({Progress Startup Column}, "Backlog", {FPI Column}, AND({KS_Start-Up Report Range 1} >= DATE(2024, 4, 1), {KS_Start-Up Report Range 1} <= DATE(2024, 4, 30)))
-
Can someone help on this formula please?
Hi all , Can someone help with the below formula please, I am struggling to find the correct formula ? hopefully the information given makes sense , thanks See snippet below of the columns. I only want a date in the 'Quote SLA For Remedial' column if the 'Remedial Status' Column is either 'Remedial Required' or 'Overdue…
-
Number as text throwing Formula off
Hi All, I created an invoice tracker. To identify duplicate invoices I created an "identifier column" with a formula. (=IF(COUNTIF ([invoice #] : [Invoice #], [Invoice #]@row) >1, "Yes", "No") and subsequent conditional formatting if it is "Yes". I've run into a snag. Invoice #'s come in all shapes and sizes and it seemed…
-
date needed before being able to keep entering data
hi, how can I make smartsheet require someone to enter a date in a cell before continuing to enter data. I want to make it a required field before being able to continue entering data
-
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…
-
How to calculate the expected % complete at a particular date?
Afternoon, I am trying to illustrate some expected % vs actual % completed, using two dates. So far I have input the below which based off today shows the task should be 42% complete. =IF([Start Date]@row <= TODAY(), NETWORKDAYS([Start Date]@row, MIN(TODAY(), [End Date]@row)) / [Duration Between Start & End Date]@row, 0)…