-
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.…
-
Converting Dates to Month and Year
I am trying to use this formula to get my dates to just show the month and year. However, all of my January dates are missing the year. Why is January missing the year? =IF(MONTH([Start Date]@row = 1, "January", IF(MONTH([Start Date]@row = 2, "February", IF(MONTH([Start Date]@row = 3, "March", IF(MONTH([Start Date]@row =…
-
Calculating % with a minimum value
I'm looking for a formula that calculates the percentage of two columns, but shows a minimum percentage of 50% if the calculation is less than that. Is this possible to do in one column, or do I need to have one column with the percentage, and the next with an IF function? My knowledge of functions is limited so thanks in…
-
VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date. In a separate Smartsheet, we will be managing service tickets and certain types of requests…
-
COUNTIFS multiple columns
Hi @Paul Newcome I have another interesting scenario I wonder if I can solve with a formula. I have three columns with numbers 1....5 I want to calculate between those three columns anytime a value is >=1 to count as 1 and not every time the value is true. I know I can count the three columns =COUNTIFS([Summer…
-
Formulas and Links to Other Sheets Disappeared
I have a large project sheet that contains (1) cross-sheet links and (2) formulas to calculate due dates based on other tasks. I needed to change the sheet to only populate weekdays (no weekends) so I turned on the dependencies and edited the workdays. Then I realized ALL of my cross-sheet links and formulas disappeared! I…
-
How to calculate total hours of work per month for each resource
Hi all, l am trying to sum the total number of hours each person within our team has worked across different contracts. However l am not sure the correct formula to use for this? I believe if would be a SUMIF but every formula l attempt either brings it back as invalid or unparseable. I have attached a screenshot the…
-
Status RGYB balls formula, when due tomorrow and past due
I built out this formula to change the status marker balls colors based on today's date and my "due Date" column: =IF(Status@row <> "Complete", IF([Completion/ Posting Date]@row > TODAY(10), "Blue", IF([Completion/ Posting Date]@row > TODAY(5), "Green", IF([Completion/ Posting Date]@row > TODAY(2), "Yellow",…