-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…
-
How to add hours in the column if date format is in text/number?
Hi All, New here in Smartsheet. I would like to ask what formula can I use in column 5 to achieve the expected date and time if I add column 2 and column 3. Current Formula in column 4 is =IFERROR([Column 2]row 3 + ([Column 3]row3 / 24), 100) If I put in actual excel file it is working as per expected result in column 5…
-
Formula
I have a series deliverables reference from another sheet (sheet 1). In this sheet (sheet 2) I list those deliverables under an objective and I want to rate the entire objective based on the highest risk in my Symbols (Red being the highest risk, then Yellow, Green, Gray) what would be the formula. Same thing for the…
-
Need Formula to Match Names in 2 Different Sheets
I have a list of people in one sheet and I need to know if the names in another sheet are included on the main sheet. What's the easiest way to go about this? The tricky part is on the source sheet I have a column for first and last name, and the supplemental sheet that I need to check against has separate columns for…
-
How can I change the color of a cell if five certain columns all contain "Located" or "Clear"?
I have a column named "Ready". I want to change the color of the cell in that column to green if the cells in these five other columns all contain "Located" or "Clear". I've figured out how to check a box if any of these columns contain "Delayed" but I want a visual representation if the row is completely ready. I've tried…
-
Need to flag an entry that is a duplicate of a previous entry that includes time
I have created a solution for our staff to reserve desks when they are coming in to the office. They select the desk, the day and if they want it for the AM, PM or All Day. By using formulas and helper columns I can get the solution to let a person know when their reservation is double booked based on the desk and date…
-
Help with Anniversary Formula
I have a sheet where I would like a [Next Anniversary] column to display and automatically update the next upcoming anniversary of [Hire Date]. I don't want the [Next Anniversary] column to display the date and month with the current year, because some of the dates have already passed. (ex. if [Hire Date] is 2/5/19, I…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
How to calculate number of days a project is at a certain status?
Hi all, I am looking for a way to calculate the number of days a project is on hold based on a change of status. In my theoretical planner, I set a project start date and input an estimated project duration. This calculates a predicted end date. I have a column where I can define the project status, these are "In…
-
Using COUNTIFS with AND in Summary Sheet
Current Formula is for # Enrolled =COUNTIFS(Enrolled:Enrolled, 1, [Course Name]:[Course Name], "Name of Course") I need a formula for Enrolled AND # Late Status Red X
