-
Adding two COUNTIFS
Hi, I am trying to add two COUNTIFS from different sheets and using the formula below. =COUNTIFS({Engineer Live Rota}, $Name@row , {Date Live Rota}, >=DATE(2020, 2, 1), {Date Live Rota}, <=DATE(2021, 1, 31) + COUNTIFS({Archived - Rota Range 1}, $Name@row , {Archived - Rota Range 2}, >=DATE(2020, 2, 1), {Archived Rota Range…
-
countifs not working via choosing whole column or selected cells
Dear team i try to count the delayed task using Countifs. But this formula is not working either manually typing my column header or choose whole column or selected cells. So my asking is how to add the range fast and correctly?
-
I need to pull certain data from a sheet to another with specific criteria such as (completion 0%)
I am trying to write a formula that allow me to pull certain data from another sheet with completion % 0 and with specific type/name. I need help with the formula
-
Allow simple formulas to be add to cells in Reports
I can enter a simple formula in a text cell in a sheet but not the same cell in a report. I have a "Shipping Report" that our shipper uses when the ship out an order. It pulls the client's name, address, due date, tracking number, and shipping cost cells for a sheet. The shipping person can enter the tracking number, and…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
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…