-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
Autofill Dates in Rows
Hi, I am looking to autofill dates in rows, not columns. I can't set all the column types to date and am unable to figure out a formula to generate dates in row. Thank you!
-
Populate Quarter based upon date
I would like to populate a field called Quarter based upon Week Start Date field. All I need in the Quarter field is Q1, for example. Q1 = Jan - March Q2 = April - June Q3 = July - Sept Q4 = Oct - Dec I have tried to figure out the formula, but haven't been successful. I have manually been adding the information into the…
-
Adding Current Month Data To Dashboard and Metric Widgets
Hello Community, 1st Question: I am creating a dashboard for our compliance statistics. I have built out a dashboard calculation sheet based off other sheets as seen in the image below. I am looking to add only the current months lable and associated data to my dashboard to keep it clean. 2nd Question: I also have the…
-
Search and find the last sequential duplicate key in a Smartsheet?
I have a target sheet that has duplicate keys where the keys/rows can be found throughout the Smartsheet. I need to display the column named 2501_January value from the last sequential key's row in the target sheet. In this example, I want to search and find the last Row Key Rev-2 at the bottom of the Smartsheet from my…
-
Formula to search across multiple contact column
Hi, we are using the following formula, but it only works for calls with a single contact per cell, even though is looking into multiple contacts per cell. We managed to fix this by using a helper column that's the same as the contact column but set as text property. Is there a way to make the formula work with the…
-
Due date vs when NEW ETA is entered - Formula help
Good morning. I know I'm missing a closing bracket somewhere but I can't figure out where. What I'm trying to do is show 1 - 4 wks out and then anything further show 5+ Wks out BUT… I need it to look at the due date UNLESS a NEW ETA is entered, then I need it to look there. Here's the formula I have thus far IF(TODAY() >…
-
Countifs for cells containing a letter
Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks. My formula is below and I want a solution for the…
-
Help with an Index Match Formula - If Error Required?
Hello! Currently using the below formula to pull data from one sheet to another. =INDEX({Survey Home Name}, MATCH(Home@row , {Optician Ear & Dental Care Company Survey Range 1}, 0)) I'm getting a #NO MATCH error for any data not yet on the first sheet, but I would preferably like this to return as 'no'. I wasn't sure if I…
-
Subject: Help with INDEX/MATCH Formula – Pulling Data from Sheet A to Sheet B
Hello, I’m having trouble with an INDEX/MATCH formula that's intended to pull data from Sheet A (Zoho) into Sheet B (Hub) based on matching email addresses. Here's the formula I’m currently using in Sheet B: excelCopyEdit=INDEX({Zoho Report Range 2}, MATCH([PERSONAL EMAIL]@row , {Zoho Report Range 3}, 0)) However, the…