-
combine vlookup formula in one row
This may be two questions in one, as match index may be a better solution but right now I only know how to use VLOOKUP. I have two sheets pulling data from other sheets, one tracks number of routes run as Lead or Second for a particular route; the other tracks the patroller QUAL for each route ' L, S, T, -,' I would like…
-
Help converting excel formula to smartsheet
Hello! I'm working on converting a labor budgeting spreadsheet from Excel to Smartsheets. I've been able to convert most of the formulas over but I'm stumped on this one. I'm trying to reference a few other sheets to collect name and zone they're working in. I have this formula for name: =IF('Outbound Staffing…
-
Check a box in new column if duplicate value is found within a particular column
Hello, I'm trying to move a row to a new sheet when a duplicate serial number is added to a sheet through a form entry. Is there a formula I can use to check a box if a duplicate value is found in a serial number column of a sheet? Thanks, Mary
-
IF certain columns are not blank then autofill another column based on this?
Hi, I want to autofill a column [Column 1] based on whether a number of other columns contain text/date, i.e. IF [Column 2] is not blank then put '-' in [Column 1] IF [Column 3] is not blank then put 'P1' in [Column 1] (this would override above) IF [Column 2] is not blank then put 'P2' in [Column 1] (this would override…
-
Trying to surround Text with other characters in sheets
Im trying to see if there is a way to surround text within one of my cells with asterisks on both sides "*". Im trying to accomplish this in a helper cell after submission within my form goes to a sheet. Similar to the function in excel- ="*"&A1&"*" but with "A1" being the cell I'm trying to surround with asterisks…
-
PTO Employee Absence and Reason Function
Good morning, I have created a spread sheet listing the employees and their reason for absence. I would like to make sheet summary to account for each employee and their reasons - so for instance... Team Member: Sarah Type of Absence: Appointment (there is a drop down list of reasons) #Days : 1 What function would I use in…
-
IF/OR formula for column
Hello, I'm looking for a formula that I can apply to the whole column with the following logic entered in each of the blue columns. If the "Month" column if "January, then fill in the blue cells with correct months information on the right. Ideally, the first row of blue cells should match the 3 purple cells to the right.…
-
Help with a dynamic status column
Hi- I have a {{Status}} which is a drop down containing the follow options "Not Started", "In Process", and "Complete". I have 4 columns which are checkboxes. I would like the {{status}} to dynamically update based on the check boxes in the columns. If all the checkboxes@row = 0 then status would be "not started" but if…
-
How to set up multiple criteria on countifs
hi, I want to set up formula to count ideas that are: 1) Not checked in SCC, 2) Approval Status is not "Cancel/Reject", Portfolio is "ADA/Commerical", but it always gives me count as 1 only. I don't understand it. This is what I use in filter This is formula I use: =COUNTIFS({IDEA Request Sheet Range 1}, =0, {IDEA Request…
-
What is the Default data type for "auto-numbers"
I've created a "Client Database" using a sheet. We had 400+ rows of details input via an upload during the setup. Subsequent clients are added via a Form and the new client number is assigned via "auto number". In our project portfolio sheets I am using a Index Match formula to pull client groups and client name instead of…
