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 "DEL…
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 dropdo…
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 s…
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.
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 for…
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…
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 hel…
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 wan…
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 wou…
