-
VLOOKUP w Dates, get "No match" back
Hi there, I am trying to use a VLOOUP formula that references a column in my existing sheet (a date) and then goes into a fiscal week lookup table. Matches the original date and displays the fiscal week match. To simplify I have spelled out every date in column 1 and fiscal week reference in column 2. My formula is this…
-
Formula Help
My ultimate goal is to have a checkbox checked automatically. I have two sheets...(Employee Staff Schedules) and (Schedule Compliance) Each Friday employees provide their schedules through an Employee Staff Schedules Form. The Form includes the Employee Name, two date fields (Week Start Date) and (Week End Date) and then…
-
Formula to pull in Quarter from a reference sheet
I have created a reference sheet called Quarter Reference Sheet that has the quarters based on a start and end date: I have another sheet where I want to create a formula that pulls in the "Quarter" column above based on if the "Completed Date" column falls somewhere between the Start Date and End Date in the reference…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
Index with Multiple Critera
Hello, I'm trying to Index information from another sheet that meets multiple criteria. All columns in the other sheet match the one below. In the Agent cell, I want to index from the other sheet (Master Sales) the Agent name If Status is either Closed or Pending and If Weeknumber = Weeknumber @row. As you see, I'm getting…
-
INDEX/COLLECT FORMULA PUSHING OUT "#INVALID VALUE" - CAUSING CHECKBOX FORMULA TO FILL IN WITH SAME
I'm trying to gauge training impacts for different business areas within my organization for specific projects. I have a sheet in the background that's pulling if the business area has marked if they have a "training impact" or not in relation to a specific project. Example: Business Area 1 responded "Yes" to having…
-
Formula: Add a total from specific rows when check- box is checked.
I am using SS for our bid sheet and I would like to save Quanity's and their related prices for every possible add-on. How do I write a formula that states add all of a particular column ONLY IF the box is check-marked in the row?
-
Formula to determine a specific date within a month based on date ranges.
Good Morning, I am trying to determine a formula to produce a specific date based on date ranges. So when a date (mm/dd/yy) is entered into a column if it is between the 1-15 day of the month, I want it to populate the 25th of the same month into a column- (mm/25/yy), however, if the date is 16-31 day of the month, I want…
-
How to have a date dynamically changed based on a value in another column?
I'd like to be able to have the dates in a column update based on the Sprint number. So, I've created a new sheet with one column with the Sprint # and a column for the associated dates. I have a column in my main project spreadsheet titled Sprint #. I'm having trouble figuring out how to tie it all together. I've been…
-
IF Condition issue
Hi, Can someone help me why i am just getting the value as Quarter if i change the value to less than 25 in column =IF([1.1 Landscape]1 > 0.0025, "Quarter", IF([1.1 Landscape]1 > 0.005, "Half", IF([1.1 Landscape]1 > 0.0075, "Three Quarter", IF([1.1 Landscape]1 > 0.001, "Full", "Empty")))) THanks