-
How to use the data in the Predecessor Column as a variable.
Im trying to use the number inside of the predecessor column to call out the location of the row to get information from that row. =VLOOKUP([Predecessors]@row, {Predecessors}, {column x}, false) =INDEX([column x], MATCH([Predecessors]@row, [Row])) none of these seem to work. Is there a way to call the predecessor column as…
-
Calculating Time Worked for Employees
I have a start time and end time in my smartsheet but need to calculate hours worked. Has anyone used a formula before to do this? if so can you pass along?
-
Is it Possible to Automatically Update a Dropdown Based on Booking Counts?
Hi there, I need some input on setting up my workflow and I'm unsure if it's possible. I have a scheduling sign-up sheet where people sign up by date, and each date has a limited number of spots. I want the date option in the drop-down to be removed once the count of bookings for that date reaches "0." Screenshot below for…
-
Duplication detection after initial row of information
I have reviewed some of the other solutions for duplicate detetion but am finding those formulas are not tailored to my situation. I need to keep the initial row and hide the duplicates. In the formula I'm using, I need the church or organization row with the oldest date to remain unhidden, while the remaining rows with…
-
I want to create an equation based on complex matrix
I am trying to change the status of a column, base on the top five impact levels ( Not Significant, Minor, Moderate, Major and severe) based on the conditions below. Would I have to nest in 25 equations, or does smartsheets have a simpler way of reaching this solution?
-
Percentage of check boxes - Need to exclude blank cells
Hello! I am working on a formula to calculate the percentage of boxes checked. This formula is currently working when I set the range to exclude the blank cells. However, I need to allow space for more rows to be added in the course name column in the future. I would like to make this formula to exclude those blank cells…
-
Finding a value from one sheet on another sheet and transferring cell info onto both
I need help figuring out a formula that will cross reference between two sheets. I have one sheet that stores our open orders and another that tracks our orders undergoing quality assurance. What I need is a formula that takes the order number from the open order sheet and searches for it on the quality assurance sheet,…
-
Tracking Time
Hi, I am new to Smartsheet I have a form that send info to a sheet. With that I need to track time based on a chosen activity and there may be 3-4 entries between start and stop of time tracking. I cannot figure out how to set up the auto part for this process. Thank you, Liz V.
-
create a formula
I try to learn how to create a formula that says : if the cell is not blank, create this. actually, I have a row ID generated with this : =IF([ID de ligne]@row = ""; ""; "OFFRE" + "-" + [ID de ligne]@row) = OFFRE-043 I would like to create this ID only when the row [DATE DE L'OFFRE] is field.
-
automate reference to a row number
Hello, I have this formula that refers to the specific range of row numbers: where 1348 and 1377 are the row numbers. I have to change it because I use this formula for different months and different individuals and I have about 12 000 rows in a single sheet. Is there a way to automatically refer to a row number? (right…
