-
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.…
-
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…