-
Populate Column From Another Sheet's Dropdown Menu
Hi all! I was wondering, is it possible to populate an entire column based on the dropdown menu from another sheet? I have one sheet where all tasks are listed, and are assigned to people via a dropdown menu. I am trying to create another sheet as a cross sheet reference that summarizes hours of every individual. What I…
-
Is it possible to reference another sheet's dropdown list in a formula?
I'm working on a formula to reference another sheet, where the other sheet includes various dropdown menu columns. I want the formula to include an IF statement where, when a cell is selected in the sheet, it populates a corresponding dropdown menu from another sheet. I completed the formula, but the dropdown menu does not…
-
Requests Per Month
I am trying to figure out a formula that will allow me to keep track of number of requests per month. I have tried countif, countifs etc., without much luck.
-
How to Count a Multiselect
Hi, How to count a multi-select. I have the count for Columbus and Cleveland. How do I count the ones that are selected Cleveland Columbus.
-
How to Have Formula Continue to Next cell When Dragged Down.
I am creating a delivery & install sheet. On the delivery sheet I have a column that is a date property, on the install sheet the correlating column is also a date property. I am using the workday formula, "(=WORKDAY({Exterior Delivery}, 1, {Holidays Range 2})". The problem is the function won't apply to the other cells…
-
A 2-part formula question
Good afternoon Community, I'm working on a new summary sheet and have a 2 part question I need help on…Some background: I have a sheet to track our recruiting efforts and am working on a Summary Sheet I'll use to build a dashboard. PART 1 I need to count how many reqs are open each month. This would include any reqs that…
-
Merge multiple columns into a single column on another sheet?
Hi, I have 3 columns on the same sheet (C1, C2 and C3) and I want to Merge them into a single column "A1" on another sheet. Is this possible in Smartsheet and how can I proceed? Thank you for your help. Best,
-
Calculate Working Days with blank field
Hi there, I'm trying to calculate the number of working days on a sheet between 2 date columns ("Date Opened" and "Candidate Start Date"). However, if the "Candidate Start Date" column is blank, I want to calculate the number of working days between Today and "Date Opened". I was hoping someone could just check my logic…
-
Extract text string into separate cells
I have predecessors which I converted to text in a separate cell. Below is what it looks like… If I wanted to extract "181," "182," and "184SF - 20w" into separate cells (three cells in total) how would I do that? Thank you!
-
Same Formula Giving Error in Different Cells
Hello, I have a formula that should be the same for all three calculations I am trying to do but two are giving an error when I think everything about them is the same. Here are the two formulas I am using: The Insp Date produces a number/no error and the Weld Date produces #INVALID DATA TYPE. The are in the same column on…
