-
SUMIF a field if box unchecked
I'm trying to sum a column, [Total Commission], if [Rep] is ES and the [Rep Paid] column does NOT have a check mark. It's looking like this so far: =SUMIFS([TOTAL COMMISSION]:[TOTAL COMMISSION], [SALES REP]:[SALES REP], "ES", [REP PAID]:[REP PAID], ??? (this is where I get lost.) Help?
-
Vlookup/cell linking
Hi All, I've been having a lot of trouble with a vlookup formula that I have linking a sheet with ALOT of columns--just under 200. There seems to be a limit to the number of columns to 'look at' (which is 85.) This is the last formula that I have which works. =VLOOKUP(TODAY(), {1. DOR (Pull-out) Range 1}, 85, false) I…
-
Problems using IF formula to calculate status
Hello, First post for a new Smartsheet user. I'm trying to do an status formula. If my % Complete column is 0% then the status should read "Not Started", If the % Complete column is 100% then the status should read "Complete", any percentage in the % Complete column that is not 0% or 100% should read "In Progress". I'm…
-
Formula With a date
I am having an issue with creating a formula that will count a column if a row has a date in it. It can be any date just as long as it has a date. PgM Status is the column with the date right now I'm just counting the section that has the dates but would like to create a formula, so I don't have to keep adjusting in the…
-
Nested SUMIF+cross sheet formula
I am struggling with a formula. I have two sheets. One is a list of proposals, the other is a material forecast roll-up. I am trying to build a formula that will sum up the square feet noted for a particular product within a certain month and year, but I can't seem to get it right. Here is what I have so far:…
-
COUNTIFS for Projects Completed Within Past 90 Days
For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days. =COUNTIFS({Project Type}, "Course", {Organization}, Metric@row, {Completed Date}, <=TODAY(-90))
-
Range name
Hi everyone, I have a question about the range name and description. When I use formula with another sheet it calls automatically like {range Count}. Later, when I try to find out, which sheet data is being used in the formula, I can't find the sheet and range because I just forgot it and it is not mentioned in the range…
-
If cell is empty or blank,
Hi, I have currently formulated the following formula, =IF([Days (Difference Forecast - Baseline)]1 <= 5, "Green", IF(AND([Days (Difference Forecast - Baseline)]1 > 5, [Days (Difference Forecast - Baseline)]1 <= 10), "Amber", "Red")) which is working efficiently, but problem occurs when the cell is empty, and it show me…
-
Product Selection using Contacts
Hi Just thinking aloud... is there any reason why I couldn't import my product inventory into 'contacts' and use the 'contacts' feature as 'products' and be able to select multiple products in one cell on a row? And then do counts of products within a sheet or a selection of rows? Thanks Cheers Richard
-
Week Ending Date
Hello, I am creating a Safety Audit Database. Similar to Scheduling principles, we keep track of all data entries by two dates. ACTUAL DATE and WEEK ENDING DATE (where Week Ending date is Sunday) We use a formula in Excel to do this but I am not able to replicate such formula in smartsheet. Does anyone know how to do this?…