-
Formula to return a status based on due date
Hello, I am trying to return a status for projects based on due date. I have a date column for Due Date that has some blanks and another column for the Status. In the Status column I have the following formula: =IF(ISBLANK([Due Date]@row), "", IF(WEEKNUMBER([Due Date]@row) = WEEKNUMBER(TODAY()), "This Week")) This is…
-
I want to update a cell if any of the cells in a certain range of cells equals a certain text.
If ANY cells in Status3- Status7 = In Progress then I want Status2 to equal "In Progress, If ALL cells in Status3-Status7 = Complete then I want status2 to equal "Complete" @Paul Newcome @Andrée Starå
-
Formula for today's date as day ___ of 365?
Hi there! I need to make a simple dashboard metric widget displaying the current day's date as day ___ of 365, as a percentage. Even more specifically, if possible, I need to do this same thing for today's date as day ___ of [number of days in current quarter], as a percentage. Examples: Today is Feb 18, which is day 49 of…
-
Formula needed: Multi drop down select column to output value in another column
Hi All, Any help with a formula? This is driving me nuts! Basically what we're hoping is to be able to select multiple values within the "Rate_Card_Tactic_T4/T5 column", and output the dollar amount that is assigned to that tactic in "T4/T5 Cost - Email Blast" column. This is as far as I've gotten... it works only if I…
-
Formula to value cell based on 3 other cells
I'm struggling how to write a formula for a Job Status Column, which is based on whether or not 4 individual date columns have a value in them. If date Column 1 has a date, then the Job Status Column should automatically show as "25% Complete". If date Column 2 has a date, then the Job Status Column should automatically…
-
COUNTIF FORMULA (3 Columns, 1 Column includes contact)
Hi All, Need help with a formula! I need a formula to summarize the following criteria. If Project Track = XX, and if Project Phase = XX and if Project Manager = X Person" what is the output? My current formula, but it doesn't seem to be working. Is it due to the fact that the Project Manager filed is set to contact list?…
-
Link latest update from one smartsheet to another
Hello everyone! I am having a bit of trouble trying to come up with a formula that will automatically pull the latest update from one smartsheet and copy it to a cell in a different smartsheet. The latest updates are entered via a form by the users and the latest rows are shown at the top of the sheet: I want to copy the…
-
Quantity in cell to rows
Hello, I have a column named "Quantity" and the cells of that column, I have numbers (any number). Is there a formula or a function that can create new rows (specifically of the quantity) in that sheet or another sheet automatically? Is that something this is automate-able? Example: If cell A1 in Sheet 1, has a quantity of…
-
How do I populate a list of values from one column if a checkbox is selected in another column.
Ideally, I would like to populate all of the values in column 2 into one cell if the checkbox is selected in column 1. I would like each title to be on it's own line in the cell. For instance, The cell should look like this: Adjusting to Remote Work Life Admissions Processing & Review Advanced Capture (AnyDoc):…
-
CountIfs cell contains a value from a string
I have a drop-down text column from a sheet that may contain the string "Day 0" "Day 1" "Day 2" "Day 3" "Day 4" "Day 5" or allow the user to enter a different day value. I am trying to count if the cell contains any of the 6 values from the drop-down. I do not want to count them if the user entered a different value (i.e.…