-
Automatically Copying a cell from another cell but with edits
Hello, I have 2 columns called " Location" & "Observation report Number". The Location column is a drop-down list of 4 options (WH1, WH2, JS1, JS2). I would like to have the "Observation Report Number" column to auto-populate with the location in addition to a number at the end of it. For example, If I manually enter the…
-
I have automatic color dots, how do I add the If status (Due Date) is complete, return gray?
=IF([Due Date]3 < TODAY(), "Red", IF([Due Date]3 = TODAY(), "Yellow", IF([Due Date]3 > TODAY(), "Green"))) currently using the above formula to automate color dots for task health, however when an item goes complete it stays as RED. I'd like it report out as a gray.
-
Multiply Different Columns w/ IF(Or
Hi, I am pretty new to formulas and am having trouble merging the two formulas below. I've tried IF and IF(OR and IF(AND, not sure how to do this. Basically, if there is a green dot, I want to multiply two @rows and if there is a blank I want to multiply two different @rows for the $ amount to be in the RENTAL COST FULL…
-
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