-
Counting Dates
I am trying to get a formula that will count the number of times a date appears in a particular column.
-
Is anyone else struggling with duplicate assignments (i.e. Assigned To field)?
Hello! We recently moved a manual task assignment process to Smartsheet. The issue we're experiencing now is duplicate assignments. 10-12 team members are accessing the sheet at any given time. Changes are happening all the time. And while they are refreshing and saving consistently, team members are stepping on each…
-
Return a date from another sheet based on two columns in source sheet
I would like to be able to return a date in column "Due Date" based on conditions in columns A, B, and C. The dates will be pulled from a second sheet. If Sheet 1 column B is "PU," I want it to search Sheet 2 for the same entry in Column A as Column A in Sheet 1 and return the result in the 2nd column. If Sheet 1 column B…
-
Error on Index/Match Formula
Can someone PLEASE tell me what is going on with my formula? I'm trying to do a simple index match and it's giving me an error message: However, I have confirmed that the session codes that I'm matching on are present in the sheet that I'm using to cross reference. The only thing I could think of as to why it's not working…
-
IF((CONTAINS)) function
I'm trying to verify that the emails in a column have the correct spelling. I'm using an IF((CONTAINS)) function, but it's not working =IF(CONTAINS("@kintegra .org", EMAIL@row ), "", "Check eMail")
-
Health Ripple Effect Formula
On my project plans, I use a Red/Yellow/Green/Gray column called [Health], and I also use the stock [Predecessors] column. I'm trying to come up with a column formula so that if I change the [Health] value on a given row, it will update the [Health]@row value of every row downstream that directly or indirectly uses the…
-
Formulas
If you have different numbers per line in the barcode column, you can see which product it actually is from these numbers. For example, 9040005530102: from the first two digits, you know that this product is DIM90. In the same barcode column, after scanning, you may also see other numbers such as 10040005590117, which is…
-
Can Smartsheet add SUMIF statements together? Struggling!
Hi all - I have successfully created a column with two cross-sheet references. The Concatenate Row adds the brokers name and the MM - YYYY. =SUMIF({Invoices Range - Broker 1}, Concatenate@row , {Invoices - Rev to Broker 1}) I want to add multiple SUMIF formulas together here is the formula I tried and getting error message…
-
Harvey Ball status based on due date
Greetings Hope everyone is doing well. I have a need for some guidance. I've used a similar formula in the past but I am having issues with this one. What am I trying to do: I have a status column and RTDD date column and Symbol column for the Harvey Balls (red, yellow, green, and gray) I'm looking to have the balls color…
-
Added 2 years to date, only want to populate in specific fields
I have created a calculation to add 2 years to a specific date listed in a field, but I would like to create a formula where it calculates the 2 year date but only populates if the other field is filled in. Current formula: =DATE(YEAR([PO Date]@row ) + 2, MONTH([PO Date]@row ), DAY([PO Date]@row )) If the PO date is fill…