-
Is there a shorter way of writing this IF statement?
Here's the working statement: =IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Merit Medical", [BILLED BY]191 = "Don Joy"), STATUS191 = "Paid"), CHARGES191 * 0.14, IF(AND([Account Owner]191 = "JK", [SALES REP]191 = "JK", OR([BILLED BY]191 = "Cerapedics", [BILLED BY]191 = "Surgentec", [BILLED…
-
Split-screen auto populate?
Hello all! I have a smartsheet that is always open in our warehouse to let the guys know when an item needs to be shipped; the line is added by our procurement team. After the warehouse personnel complete a shipment, they mark the status of that line as complete and save. The line then gets crossed out but stays in the…
-
Creating Summary on the Fly
This may be a dumb question but I have a sheet Orders that is auto-updated every morning via the Data Uploader. So the list of items changes on a daily basis... sometimes the same items are listed and sometimes new items are listed as well. Is there a way I can create a summary sheet or grouping of duplicate items and…
-
If forumula
I trying to write a formula if (Days)<=30 will display an Amount in column 0-30
-
Referencing other sheets
Ok I have one sheet that I have a formula in that references the data in another sheet. The name of the source sheet is "Drug Seizures" When I start my formula in the destination sheet, I click on reference other sheet, select "Drug Seizures" and then the data I want to reference. When I look at the formula in the…
-
Nested IF Formula Help
I have two Nested IF formulas that work separately, but keep given me an "incorrect argument set" error when I combine them. The two formulas are: =IF(OR([Current Status]1 = "Completed", [Current Status]1 = "Terminated"), "Blue", IF(AND(OR([Current Status]1 = "Planned", [Current Status]1 = "Allocated", [Current Status]1 =…
-
Method to update field automatically (based on other field updates)
I was looking to see if there was a way to make an update to a field based on the status of other fields in the sheet. In my example I have a review process that sends multiple emails at once for review and approval. The reviewers each have a field that the indicate approved or rejected in. Once all of them have approved I…
-
RYG Balls
For this formula, I would like the RYG balls to be the result. Instead, I’m getting the word “Green” or “Red”. So the formula is working, but would like the balls and not the word.
-
If - Then - Else
I'm trying to create an If/Then/Else statement to determine if an employee is eligible for a pay increase. Essentially, the formula needs to say IF Mandatory Training Requirements Met = YES AND Corrective Action = NO THEN Eligible for Increase = YES ELSE Eligible for Increase = No Any thoughts on how to accomplish this?
-
Auto-fill is outdated
The conditions that formula auto-fill performs in are ridiculous (based on the row above/below). It's incredibly temperamental and not fit for purpose. Likewise if you copy a formula down a column, I'm experience the following problems: * When you add a new entry into the card view, it adds the result to the end of where…