-
INDEX/COLLECT
Good afternoon, I am used to INDEX/MATCH but this time I need to match two columns and then pull the information in a third column. Here is where I currently am: =INDEX(COLLECT({Meeting Planner}, {Meeting ID}, [Meeting ID]@row, {Vendor Type}, "A/V")) I want to pull the information in Meeting Planner from Sheet 2 when bothβ¦
-
Count The Rows in Remote sheet within two local numbers
Hello, we have delivery books with a certain number of delivery notes in it in a sequential range. in this example, there are 15 delivery notes in each book. I Have 6 different delivery note book types. Purchase Note Book R.E.L Record Note RO-RO Record Note Scrap Container Service Record Skip Record Note Waste Controlβ¦
-
Why does my column return #INVALID VALUE in random rows
I have a training matrix and want to record total hours trained so have added a helper column to the end of each course to record the length of the course and then I have added all columns to produce total hours spent using the following formula (a bit long but only way I could get it to work!). The formula has worked onβ¦
-
How to delete cells when a column has been converted to a formula column
Hello, I am taking the course through (SmSh Uni), Writing Formulas in Smartsheet - Self Paced. I am completing an activity given to convert a formula in a cell to a column formula. The tutorial says there will be errors in two children rows and that I can delete the two cells. Unfortunately, you can not delete a cell whenβ¦
-
Unparseable errors
I've tried a number of formulas that should work but keep on getting unparseable errors. [current process stage] does light up as found, so am thinking it's not an issue with using a column name that can't be found. Some of the formulas tried were: =SEARCH("S1", [Current Process Stage]@row =IF(ISNUMBER(SEARCH("S1",β¦
-
CONTAINS with several criteria
We are trying to calculate several criteria and pull into our metrics My problem is when i am looking for Airline, the Airline range has several criteria in 1 cell, how do i look for CONTAINS? I tried different ways to calculate it but i keep getting errors =COUNTIFS({Amadeus: TC Known Issues & Limitations Mas Range 2},β¦
-
Formula for returning value based on dates
IΒ have a main sheet and a reference sheet. On the main sheet there is a Payroll Period which is based on a Shift Date column. However, I want to add a formula that refers to a reference sheet whereby I have two dates. If the Shift date falls within the Start Date and End Date of a pay period, I want the formula to returnβ¦
-
What Formula would I used to get a return value if a range of cells in a column all have the same sp
I essentially want the image status to be "To Be Shot" if all of the cells in the sample status are marked as "RECEIVED". Then if all of the cells in a range DO NOT say "RECEIVED", I want the image status cell to say "MM". I've been using the following formula BUT I hate having to type out each cell number in the sampleβ¦
-
Any idea what I could be doing wrong?
Hi all, I need to create a formula that will collect info from a different (original project) sheet and display the right data on the cell of a new sheet (used to build a report) - that way things stay updated as the project progresses. So, a couple of things need to be taken into account, the info displayed needs to meetβ¦
-
COUNTIFS - Projects that equal a certain value and are CHILDREN
I looking to pull the number of projects under a certain package. The Package would be the PARENT row and the projects would be CHILDREN rows. Something like this below where each project also has the same package number (used for identification elsewhere) I would like to be able to count the number of Projects/rows, if itβ¦