-
Copying a row but NOT the whole row?
I'm trying to create a sheet that uses some but not all of the columns/information from a different sheet. Is there any way to use the copy row function but copy over only the columns I need? Or is it all or nothing?
-
How to count all rows on sheet and compare to all rows from yesterday, last week, last month.
Here is what I have for last month: =COUNTIFS([Request Date]:[Request Date], AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1), IFERROR(YEAR(@cell), 0) = YEAR(DATE(YEAR(TODAY()), MONTH(TODAY()), 1) - 1))) This seems to work. I am having trouble getting it to look at yesterdays totals and…
-
Metrics with INDEX and TODAY function
Hello. I am trying to combine the INDEX and TODAY functions into a formula that will return the value of a row in a column called "Redeemed" if the date in the "Date" column of that row also falls within the last 7 days. I am not sure how to incorporate the TODAY into the formula. How can I make these work together?…
-
Need help with formula - count if and combining two columns
I am new with formulas and looking for something similar. I have two columns and right now: =COUNTIF(Priority:Priority, "High") but I want to also capture if the Status is only 'In Progress' and 'Not Started'. Because right now its capturing anything with priority High... which makes sense. Each time I was adding a AND or…
-
Across 3 Sheets -> Count When Index Match (Cross Sheet from Sheet 2 to Sheet3) Equals Cell Value
I have 3 Sheets: Sheet1: Metrics Sheet2: List of Addresses (without States) Sheet3: List of Zip Codes and their States Without adding a column to Sheet2, what is the correct formula (to be placed on Sheet1) to count the number of rows on Sheet2 that have the same State shown on Sheet1? Sheet1 Data State | Count LA | count…
-
How Many Items "Closed" Recently
I'm trying to count how many items have been closed in the last 14 days - so "Status" would be "Closed" and the "Date Updated" would be in the last 14 days. I thought the proper formula would be as I have shown below, but it returns the wrong value. Any idea where my mistake is? =COUNTIFS(Status:Status, "Closed", [Date…
-
=IFERROR Issue
Hello, I have an arithmetic formula that sometimes gives me a number, and other times does not depending on if the [Completed Milestone by Month] columns are populated. When they are not populated they result in an error "Divide by Zero", which is fine. However I'd rather this not display on my dashboard. I've tried…
-
Nested If Then Statement
Greetings Smartheet Community, This is my first time posting a comment to the forum for help. I am trying to setup a nested if then statement and reaching the relentless "unparseable" response. Okay, so I have one column with about 500 rows, and each cell has a value in-between 0 and 51. I am trying to classify these…
-
Due date formula based off priority
I'm trying to have calculate a due date based off the priority (high , medium, or low), add 1,2, or 4 days to the date submitted. I'm using something like the below, but getting an error. Any help? =IF([Business Priority]@row = "High"), [Date Submitted]@row + 1, IF([Business Priority]@row = "Medium"), [Date Submitted]@row…
-
Index-Match Not bringing in correct results
I used the Index-Match formula to bring data from one SmartSheet into another tracking SmartSheet. In the destination SmartSheet, I labelled all the columns exactly the same name as the source SmartSheet. In the primary column, I linked the primary column from the source SmartSheet. Then for each column, I used Index-Match…
