-
INDEX(COLLECT( )) where some rows are blank
Hello Community! I'm missing something here, but I'm not sure what. In this sheet I need to pull a date from a master sheet. The formula works perfectly for the first two organizations, but then the next one it pulls is simply the next cell in the date column in the master that isn't blank. It isn't the date that goes with…
-
#UNPARSEABLE with multiple IF statements
Hi, I am trying to create TEXT depending on some conditional information. I want to display text RED if my materials clear date is less than 7 days from my due and display text YELLOW if my materials clear date is less than 14 days (but greater than 7 days) and if my materials clear date is greater than 15 days, leave the…
-
How to Apply formula to dropdown columns
Production Status- drop down column- with values like In-Production, Production Ineligible etc Handoff Column-dropdown column- with values 1,0, N/A Contract Signed -Dropdown column-with values 1,0, N/A Need a formula that if for "Production Status"-Production Ineligible is selected from the dropdown then Handoff column and…
-
FORMULA HELP? max/collect/if
I am trying to get information from another sheetA to sheetB I want to bring the MAX {MVMG} month vs month growth from sheetA to sheetB if the depot column on sheet A {depot} = depot@row sheetB Lack of sleep ... I have tried all sorts of formulas any suggestions welcome and much appreciated 🙏 Please bear in mind new rows…
-
Tenure - Years and Months Formula - help!
Hi All! I know there have been many posts re: figuring out tenure, but I am super new to spreadsheets and some of the community posts keep losing me with the round ups, @rows etc, I was wondering if someone might be able to explain with my own row examples - how to get years and months of tenure using 1. Start Date and 2.…
-
Return line's value based on multiple criteria
Hello, I am looking for help in returning a particular cell's contents based on multiple criteria. I have two sheets I am working with, Primary Sheet and Data Sheet, where I will be searching for the criteria. Below is a snippet of some dummy data. I would like to write a formula where I return the value of the Work ID…
-
If/And/OR to give Status based on 2 Variables.
Hi Folks, Working on an If/AND/OR thing that I can't seem to work through. Which is frustrating because it's rather straightforward. If Col 1, and Col 1 are both "No" then I want to output "Open" into the Status Column. If Col 1, and Col 2 are both "Yes" then I want to output "Closed" into the Status Column If Col 1, and…
-
Nested IF & VLOOKUP for Checkbox
So I'm trying to write a formula to pull a date from Sheet 1 if a checkbox is checked and match it to the same email on Sheet 2 . =IF({Sheet 1 Range 1} = true, VLOOKUP([Column2]@row, {Sheet 1 Range 2}, 3, false), "") Occasionally Smartsheets gives me trouble with pulling information from date columns that I've set to pull…
-
Formula to Find the Start/End Timeline
Hello SS Community, I'm trying to find a formula to insert in the sheet summary that brings the earliest Quarter and Fiscal Year (FY) and the last/furthest quarter and FY. Thank you in advance.
-
VLOOKUP only works with the raw data, not with another sheet that uses the same source
Hi all, I need your help to understand why VLOOKUP is not working in a seemingly peculiar case. But it might just be a difference between Excel and Smartsheet, as I'm a Smartsheet newbie. I have two reports, originally it was built like this: Report 1 - draws from original raw source data file, output column 10 Report 2 -…