-
Cross-sheet referenced Date keeps defaulting to non-Date format
I have a column that uses 3 INDEX MATCH(es) to pull in a single date (there is no way this will ever pull in more than one date) using IF statements and "" if it is not found on a sheet. Formula works as planned, and I now have a System Column of "Created On" in my data (first pic). I can then change it to display as a…
-
Hi! Not great at formulas here :)
Trying to get the formula to populate tiering (None, T1,T2, or T3) based on the cabinet total using greater than, less than ranges. =IF([Column5]12 > 55 < 91, "T3", IF([Column5]12 > 91 < 121, "T2", IF([Column5]12 > 121, "T1", IF([Column5]12 > 55, "None")))). What am I messing up?
-
Check for duplicates and exclude blank cells
Hi. I am trying to write a formula that will check for duplicates in a column but skip the blanks. The normal formula I use is Countif([Column Name]:[Column Name], [Column Name]@row) this counts blanks. I have tried =IF(ISBLANK([Column Name]@row), 0, IF(COUNTIF([Column Name]:[Column Name], [AColumn Name]@row) > 1, 1)) I…
-
Help on referencing a sheet in a formula
Hi - this is the first time I'm trying to reference a sheet in a formula. The formula is =COUNTIFS(TA:TA, CONTAINS("SC/SE", @cell)) . When I reference the sheet in the formula, I get =COUNTIFS({Project Status Range 1}) . My question is how do I integrate =COUNTIFS(TA:TA, CONTAINS("SC/SE", @cell)) into =COUNTIFS({Project…
-
I have a formula that works and I need to add an additional criteria to improve the use of my sheet
=IF([Intake Status]@row = "Assigned to CHC", "C" + [Intake ID (auto-generates)]@row, " ") I need to add another selection from my Intake Status row, "Pod 2 - Health Services" so that whenever someone selects either of these two from the drop down it will auto generate a client number. I've tried multiple formulas and the…
-
How we can create a dependant drop down list
I have a form that is filled up by my colleges asking for a new project, and i have two drop down lists on it : 1. The location of the person filling the request ( Drop dowm list with a unique choice) 2. Others locations that my benificts or concerned by this project ( Drop down of multiples choises) I would like to avoid…
-
Automated Formula Question
I have two Smartsheets: Config and Labeling. Both Smartsheets have Document #'s in them. The Config Smartsheet has multiple Document #'s in each row, in different columns, while the Labeling Smartsheet has one Document # in each row, all in one column. Both Smartsheets also have a Status column with the same dropdown…
-
How to add multiple IF statements to WORKDAY function?
Hello trying to add multiple cities to a workday function. This is to subtract our ship day from the expected arrive by date. Currently, this is what I have =WORKDAY(F3,IF(OR(K3="CITY1",K3="CITY2),"-2","-10"),Sheet1!B$2:B$49) I want to add 2 more cities. The function can either be from another column/sheet that has the…
-
Formula: Read Text Column to Fill Multi-Select Column
Hi everyone, What is the formula I can use in a Dropdown: Multi-Select column (Revision column below) to select options based on text that is typed in a Text column (Notes1). For example, if Notes1@row contains "+ Change Design" and/or "Change Material" in the cell under that column, what is the formula for a cell in the…
-
Formula Interferes with Form Data
I have a sheet where the first row is full of SUM(row2:row40) functions. This sheet has a Form that submits new data and I want the new data to be included in the totals at the top. I only have 10 rows filled so far, so I expected a form submission to show up on row 11. Instead, it shows up on row 41 so it is excluded from…