-
COUNTIFS AND CHECK BOXES
I tried to go through different scenarios and look to see if this has been asked before but wasn't able to find it. I am count 2 different columns. The first column is a customer's name and the second is a check box. I want to count if there is a customer name (any) in the first column and if that column has a check box to…
-
% Variance between 2 numbers
I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
Help with IF and INDEX COLLECT
I need to collect information from two different sheets based on a cell value in another sheet. I have created the formula below, but it doesn't seem to work completely. I get an invalid value error if the employee number is not on the lookup sheets. Thanks! =IF([Airside / Landside]@row = "Airside", INDEX(COLLECT({EqNo},…
-
Formula for Date based off Dropdown
I am looking for help with a formula to calculate a due date based off a drop down. I have 3 options in the dropdown and need to calculate a date based the requested date. <10,000 = quote due in 5 days from requested date . <50,000 quote due in 14 days from requested date <100,000 quote due in 30 days from requested date.
-
Trying to create a Countif formula that includes the # of workers allocated based on date range
I'd like to create a formula that would count all of the entries in a specific column (# of Workers Allocated) IF TODAY is within the date range that corresponds to each job entry (highlighted). As I've been tinkering with the formula, I can't quite seem to get it to return what I need. It gave me an answer of 4 (second…
-
IF(AND not working as expected
Greetings, I have a project with Start/End date (Type: Date/Time) column, Status column (Type: Dropdown), along with a project health column (Type: Symbol). I am looking to control the color of the harvey balls from Gray, Red, Yellow, and Green depending on Date AND status such as If the status is complete, then gray If…
-
Count form submissions by current and previous week
Hi SmartSheet Community, I'm hoping one of you can help me with this problem- I'm collecting incident reports with a form and would like to report on a dashboard how many incidents came in for this current week, and last week. I have two checkbox columns in my sheet, one for current week, and one for last week and using…
-
Subtraction Formula When One Cell Is Blank
Good afternoon. How do I format my formula as to not allow the subtraction to take place if one of the cells are blank? =[Starting Board #]@row - [Ending Board # (Top of Stack)]@row The math is simple unless the Ending Board # cell is blank. I wish to maintain accurate inventory at all times, so if the "Ending Board #"…
-
Weekly Avg
Hello I have a sheet that calculates days opened for an item. I want to calculate the avg days open each Monday based on open items. Then build a graph to display that info. I'm stumped on how to best do this? Each time I create a formula I realize I'm not getting the value I set out to achieve. This is my formula to pull…
-
Checkbox dependent on two rows with identical data in the same column
Posted this last week, but it seems to have died on the vine. I Regularly refresh different databases throughout the year by making a copy of the old one and importing the new data into it. This results in a ton of redundant data, and I'm looking to quickly cull it. After sorting my grid by IDNumber, how can I get the "To…
