-
Help with if and and if and or statements
Hello I am trying to work out an if or and statement! I want to only return DVCEE when either the first or the last part are correct. I have been dwelling on this for days! Please send help! =IF(AND([ABC approval]@row = "ABC Approved", [Type]@row <> "SA", [Type]@row <> "ST", [Type]@row <> "SO")), (IF(AND([Type]@row <>…
-
IF Formula using multiple cell values + date
Hello, I have a formula for employee referral bonuses that calculates the date the bonus payout is due based on the start date if the hiring source is employee referral. =IF([Hiring Source]@row = "Employee Referral", [Start Date]@row + 30) This works fine for 30 and 60 days because it applies to all employees; however, for…
-
Formula Question
I'm developing an inventory smartsheet that keeps clothing inventory in one sheet and then a form that allows an employee to request clothing for team members. I am working if I can create a formula to deduct the quantity of each clothing apparel once it is requested. There is no approval process needed. Smartsheet 1: Kit…
-
How to count number of entries that fall between two dates
Hi! I have a sheet that has a date column to enter the initial date of contact. I want to count how many of those entries fall between 2 dates (by month) i.e. I want to know how many of the entries have a date between 1/1/22 and 1/31/22. This is my formula but it's not calculating correctly as I know I have 2 entries with…
-
Formula for Multiple Checkboxes
I have a sheet with submission form, in the form there are two different sections. One where they have to pick a checkbox option from a list of 4 and the other is one out of 8. I set it up this way to be able to provide details for each selection. I'm trying to find a formula in the sheet so I can hide all the checkboxes…
-
Capacity vs Demand Utilisation RAG Column
Hello, I'm looking to create a capacity vs demand utilisation RAG Column where it will appear with Red, Amber, Green for the following rules: Green: Total Q1 Capacity = Q1 Total Demand Yellow: Total Q1 Capacity > Q1 Total Demand Red: Q1Total Capacity < Q1 Total Demand Kind Regards, Luke
-
How to identify the first date and last date from another smartsheet column?
I need to identify the following: Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2) Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns…
-
Same Formula returning a blank cell
Hi, I am working on updating an error message to return "No Resource Assigned" however the same formula is now returning a blank cell. Both columns have the same properties (contact list), and this same IFERROR(VLOOKUP) formula has worked on multiple rows prior to this blank cell and continues for the rest of the columns I…
-
Formula Syntax Help - Identifying suffix on number.
I have a sheet tracking orders. Each order has multiple order lines (each item on an order has a separate line with a decimal suffix). I would like to identify each primary order line (order line ending with ".0" but I'm struggling with the formula. I currently have this keyed as a formula =if(Order…
-
Check a Box based on a checked box in another column
This is a formula I wouldn't typically struggle with but I am having experiencing formula block right now... I am creating a sheet where new lines of data are entered for a test that is run. The unique identifier is the "batch number" and multiple lines of data may have the same "batch number" as tests are run until the…