-
Set Return Date as today +5
hi there, i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
-
Formula DATE
Hi I'm trying with the formula = DATE subtract months but I get #INVALID EJ: 05/18/2020 to 12/18/19, when I say that subtract 6 months I get an error but if the subtraction is within the same year the error does not come out, how should the formula apply? Thank you
-
Formula Help
I have an at risk column with flags. I am need a formula that will turn the flag red when its past a due date, and not marked complete. I used this formula =IF(AND([Date Needed By]1 < TODAY(), [Cabinet Complete]1 = 0), 1, 0) this works for the current row, but when I drag down to copy to cells below, it automatically turns…
-
% 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…