Hello: In Sheet 1, I have Column A that lists courses to be developed in the next term. There are several rows, but not every row contains a course. Row 1---BUS 123 Row 2---CUL 232 Row 3--- Row 4---DS…
Hello, I've looked through different discussions to see if I can figure this out. I'm trying to find a formula that will populate a cell with the date of when the checkbox in another cell has been sel…
Hi, This seems like it should be a simple thing to do, but I'm having trouble figuring it out. Is there a way to have the parent row automatically checked when all of the children rows belonging to it…
Hello, I"m trying to get the VLookup to not display "#No Match" when the search value is not found on the reference sheet. In this case I have the columns as checkboxes, I'd like the instead the blank…
Hi all, New user here. I have different monthly metrics to comply, some are greater than or lower than a value or percentage (i.e. Open tickets beyond due date is LOWER than 10%, Survey results are hi…
Was hoping to get some tips on the following use case. I set up a Smartsheet to track all my organization's training accreditations. This includes (student, assigned coach, product course, accreditati…
I have a field with a formula in it and I want to be able to lock it so only owners and admins can edit. i cant lock the row as details have to be changed by editors in other fields in the row.
Good evening, We are looking of how we would structure a formula to calculate the % of our production job each series is responsible for. * There are 6 series (sequences) in this job. 1 thru 6. In the…
Hello, I have been creating metrics on my data in smartsheet using the different formulas. I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use t…
Hoping I've not missed something obvious, but is it possible to use "Current User" in a formula? I would like a cell within a task list to count all tasks assigned to the current user with either of 2…