-
% Planned formula
Hi to all, I need to add a % Planned to my plan. I used a formula but it didn't work. Attached you have a screenshot of my plan with the formula and the dates columns. Thanks for your advice!! Adelina
-
Trying to Sum Rows that Contain 'Countif' formulas
Has anyone had any trouble counting rows that contain a countif formula? I have tried to sum all corresponding cells and have also tried to count all the children lines and the value does not calculate correctly. My values within the children lines do contain some 0 values but there are no blank lines. Any suggestions?
-
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
-
Can we create a formula using a cell that has an IF statement in it?
I have a pretty long IF statement in a cell and want to use the results from that cell in a formula for another cell. The formula I am trying to create is VERY simple; 2 cells multiplied together. But I keep getting #INVALID. The only thing I can come up with is that it's not allowed to use the information that is…
