-
Get a list value from another sheet
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
STATUS UPDATE - Based on Date
Hello, I want the process wherein once we click on the task status for example: In Progress then start and end date are added, time time line status will read it immediately if it is "ON TIME" or "DELAYED" based on the end date. If we click on the completed - and the end date is not yet on the past, then it will ON TIME -…
-
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…