-
If a value in a cell equals the same value in a column from another sheet
Hello Smartsheets team, Hopefully a simple question, but I can't seem to get the right formula going for it. I'm just looking to see if the value in a certain cell from Sheet A (an invoice number) already exists in another sheet's column, Sheet B (essentially to prevent duplicate numbers). I've been trying with INDEX,…
-
Index suddenly stopped working
Hello, Wondering if anyone has experienced this before and can provide some guidance. I have a sheet which uses index match in column formulas to pull data from multiple other sheets. This sheet has been working perfectly for several years and has not been edited. This morning, every index match formula is giving an…
-
VLOOKUP/ INDEX : Is that a way to performa reverse search starting at the last item?
Hi all, I need to make a formula to pull data from another worksheet, based on a math, but that does this search from bottom to top. That is, I have a spreadsheet of audits that are carried out, and in each one we put the identification number of the tool used. I need to make another spreadsheet that shows the last audit…
-
Sum Values in the Range of the Cells
Dear Colleagues, I have a list of products and their quantity. Several lines can belong to the same order. My task is to sum up all the values in the "Quantity" column if the value of the "Order Number" is the same. Which formula would you recommend I use? Order | Product | Quantity | Sum of Quantity O1 | ABC | 10 | 11 O1…
-
How best to automate moving data from one sheet to another based on certain criteria?
I am trying to reference a list of people in Smartsheet A and pull associated data based on that list into another Smartsheet B. I have people listed this way: Column1: Last name, Column2: First name, Column3: email address. Also in Smartsheet A (Column6) there is an alpha numeric designation associated with each person…
-
Counting column based on date and department
I am trying to sum the number of rows that fall in a certain date period and based on department This is what I came up with but it just returns 0's, Should I be using a different formula like COUNTIF? =SUMIFS(Department:Department, [Week Ending]:[Week Ending], >=TODAY(-5), Department:Department, "Tech Unit D")
-
Why I cant use Document Builder in my Business Account?
Hi, I've just change my plan to a Business plan, and I'm interested on using the Document Builder function but I can't, it appears that I can't upload a pdf, and doesn't give me the option to click to continue to create or assign a document. Can somebody help me please? Thank you! Sylvia Elizabeth
-
Sum cost between a date range
Hi, I'm struggling with a forumula to sum the cost of items that are received between a range of dates. So far I've tried this and it returns #NO MATCH =SUMIFS([Working Budget]:[Working Budget], [Desired Receiving Date]:[Desired Receiving Date], >=DATE(2022, 9, 1), [Desired Receiving Date]:[Desired Receiving Date],…
-
Help with Category Set Up
Our company is having our department switch from airtable to smart sheet and I need help getting setup. Our department works on interior design/home staging so our records change frequently based on the status of the project (destaged or currently staged..and a couple of other staging types) On airtable when I change the…
-
Index Match Formula: no longer working
This morning our main sheet (that houses all of our pertinent data) would not load and would only display a message that said "An error has occurred in Smartsheet". After a while the sheet came back but now all of my index match formulas that referenced that main sheet are no longer working. Has anyone else come across…
