-
Vlookup and matching
Good morning, First time using a Vlookup formula. All I am trying to do is cross reference employee numbers from one sheet to another. If the employee number exists in sheet A and is a match on sheet B, I want it to flag. I think I am over thinking it, Any help would be appreciated. In the screenshot, the formula will…
-
Automatically add formula to new rows
I have a sheet with a formula set up to find duplicate email addresses. But, when new rows are added, the formula doesn't copy to the new row. Is there a way to make the the new row also includes the formula. Sidenote: when a new row is created, it also triggers Zapier functions so I can't just drag the formula down into…
-
Formula
HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet…
-
Formula Help Please!
Hi Community- I have a column that I want to say what phase a project is in based upon the criteria below 4 Possible Phases – “Strategy & Intake”, “Brief Finalization”, “Detailed Concepts”, “Production to Market” #1 “Strategy & Intake” – Milestone “BRIEF COMPLETED & APPROVED” is not checked and is not in the next 21 days…
-
get list of projects worked within last month (without helper fields)
I have a task list that includes what project the task belongs to. The project field is filled in manually (not a preexisting list). I would like to setup a dashboard to show a distinct list of projects that had been worked on, how much time was spent on them, etc. Where I am having trouble is how do I get a distinct list…
-
Health Ball Color Based on Dates and % Complete
We are utilizing the RYGB properties for our Health column and trying to improve the tracking of each task using this criteria: * If a task has NOT started and no progress has been made, no color indicator * If a task has started and is not late, but progress has been made, green color indicator * If a task is 100%…
-
Auto-generate date/time field data based upon existing column
I have a sheet where I have a Status column. When I chose "complete" in that Status column, ideally I'd like to have another column (let's say it is named "Completion Date/Time") to auto-populate with the date/time (preferably just time) that "complete" was chosen from the Status column. This seems like an easy ask, but…
-
Date filled in from selecting a checkbox
Community, I want a date to be filled in when I select a checkbox. I came up with the following formula but supplies the current date. I want the date cell to show the date that the checkbox was checked. So for example, if I selected the checkbox on 09/01/19 the date column would display 09/01/19 even though the day I'm…
-
Formula Confusion!
We are trialling smartsheet and overall enjoying it so far however we have run into a bit of brick wall and any help would be appreciated! We have a main sheet with all our orders on it, using an older version to muck about with layout at set up at this stage hence the old haulage dates! Each order has details of the sizes…
-
Calculating the Number of Tickets Opened
Hi There, I am currently building a Dashboard and I want to show the number of Tickets that have been opened for a certain period, e.g. the number of tickets opened with a week. Is there a formula that I can use to achieve this.