-
Count values between dates dependent on another column value
How do I write a COUNTIFs statement to say if value in column A = "City", then count the dates between 1/1/2016 and 12/31/2016? Thanks!
-
Inventory Tracking
I'm trying to create a spreadsheet to track inventory for my business. It's very simple but for some reason, i'm having difficulty with the nested IF's. For example: the top of the sheet will list total inventory of wines; Merlot Pinot Chardonnay The user will select a type of wine, enter the quantity taken, and based on…
-
SUMIF(S) - Referencing a Range within a Range?
Hi - I'm hoping that someone could look at this and provide a fresh take on it - my goal - is not to define 50+ ranges (representing individual columns)! Use case: A sheet that tracks leave for individuals where columns are defined by week, as a user enters leave, the amount of time appears in the relevant column. I would…
-
Auto-populate request status based on checked items
We have a deployment tracking sheet with checkbox columns for each of the following steps. I want to be able to automate the Request Status column based on which items have been completed (checked) There are some legitimate situations where some of these steps may be skipped; therefore, the status should be set based on…
-
Count Check marks across columns
Hi I'm relatively new to SmartSheet and have a question. I have a set where each row represents a requirement. Each requirement may impact multiple systems. Since I'm unable to select multiple entries with a drop down - I've created 4 column - each representing an impacting system. I now need to summarize in a dashboard…
-
Nested IF Formula with Blank Cell Condition
Hi, I was able to get this formula to work, where: * 90% or higher = Green RYGG ball * 76% to 89% = Yellow RYGG ball * 75% or lower = Red RYGG ball =IF([Proj. Blended Average]4 >= 0.9, "Green", IF([Proj. Blended Average]4 >= 0.76, "Yellow", IF([Proj. Blended Average]4 <= 0.75, "Red"))) However, I am struggling to find a…
-
Formula help
Hello everyone I hope you are doing great. I need help with creating a formula for the following. I have a drop-down list, with two items, Zakat and Tax. I want to able to if I choose Zakat from the column A, column B prints today's date plus 90, and if I choose Tax it prints today's date plus 60 Thanks for your help
-
RYB Formula Help
I am having issues with developing a formula for an overall status. What I'm trying to do is based on multiple cell-status(RYB setup column) they will dictate what the overall status column of the project status is. Both columns have gray, red, yellow, and green balls. This is my current formula please help if you can.…
-
Using OR in a SUMIFS or COUNTIFS Function
Hi Guys, Smartsheet noobie here and I was wondering if it is possible to use a OR in SUMIFS or COUNTIFS function. Basically I want to sum a count values in a particular columns if either one of 2 criterias a met in another column. My basic syntax is along the lines of: Sum all the values in column A, if column B has value…
-
Count Unique SME names
Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row). I'd like to count the number of unique names in both columns. SME #1 (Name) | SME #2 (Name) Course 1 | Donald Duck | Course 2 |…