-
IF(AND(NOT(ISBLANK Multiple Conditions?
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula with multiple "ANDS" If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column AND the Provisional Requested Amount is over 50000, I want the cell to say…
-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
Count formula
I am trying to create a formula where it will count how many rows are assigned to HR within a multi-selected row. HR may appear by itself or with another option. The multiple selected rows are throwing the count off and I cannot seem to figure out how to fix it. I tried using the CountM function, but it is counting…
-
IF(AND(NOT(ISBLANK Formula Trouble...
Hello all, I'm having trouble nesting the IF(AND(NOT(ISBLANK formula. If the Provisional Requested Amount column is NOT Blank AND the Provisional Requested Amount is less than or equal to the Final Requested amount column, I want the cell to say approved... this is what I have. =IF(AND(NOT(ISBLANK([Provisional Requested…
-
Referencing Another Sheet - VLOOKUP vs INDEX vs ??
Hello, I need to populate a cell with a number that is in another sheet based on an independent UID found in a different column that will be on both sheets. Not sure which direction to go on this -- For each line form-generated line, D. needs to look at C., find/match the data to A., then populate D with B when: A.…
-
Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put…
-
Formula Syntax Error
I am trying to convert a column to a formula, but I am getting the Syntax error and it doesn't convert. The formula appears to work when in the cell and when dragged down, just not when I made it a column formula. Could you let me know what is wrong with it? =IF(AND(ISERROR(Transmitted1), [Hours - Total Timecard Hours]1 =…
-
COUNTIFS formula troubleshooting - multiple criteria and checkboxes
Hi SmartSheets Community, I'm new to Smartsheet (but know some basic Excel), but am getting stumped on this formula. Can you advise what I'm doing wrong? I'm trying to create a formula that 1) counts either Red or Blue cells in another spreadsheet column (Other Sheet Range 1), and then 2) counts a checkmark (or no check…
-
How can I trigger an IF statement only once?
I have a column that is a single select drop down menu. We use this to keep track of who is responsible for that line as the project moves through our departments. A couple of the selections are outside our company. We want to record in a separate column who the outside contractor is. I am attempting to copy the name of…
-
Need assistance writing a formula for one column with two purposes
Hello! I am creating a budget sheet and I would like to have a formula that calculates BOTH: 1) SUM across several cells in a row when box is not checked AND 2) SUM down a column if box is checked. So far, I have been able to write a formula that calculates the SUM across several cells (and have added in a bit to return a…