-
Formula for selecting checkbox will populate completion date
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 selected. In other words, when I check this box that I have completed this item then I want another cell to populate the date…
-
Automatic checkbox in parent row when children are all checked?
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 are checked? I'm trying to make a formula but nothing is working for me. Thanks, Amy
-
V Lookup-how to change "#No Match" to display different result
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 checkbox or a different error phrase such as "Incomplete" would be fine as well. My last display option would be to leave…
-
Nested IF, AND, OR/AND
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 higher than 70%, Safety observations over 30). I created a column [MEASUREMENT] stating "Higher than" or "Lower than", a…
-
count if formula help
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, accreditation level, status, etc.). I want to create a formula that counts the number of open engagements per coach. This will help me…
-
Lock a Field
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.
-
Formula that needs to reference multiple columns
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 "Series ID" column. There are 300 rows +/- that make up the 6 series * The 6 series make up 100% of the job as calculated…
-
I can't figure out how to use the OR function in a Countifs formula
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 the OR function. works: =COUNTIFS({Week}, =$[Date Range]$3, {Month}, $[Date Range]$5, {Year}, $[Date Range]$8, {task status},…
-
Use "Current User" in a formula
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 status options. I can write the formula to pick a specific name, but want to use this number in a Sight I use to help my…
-
Convert Tex to date with Data uploader
Good Afternoon, We are currently using Data Uploader to automatically move date into Smartsheet. In a few of our sheets the Date is the only unique identifier. However, I have found that using a date column to import does not work as it doubles the entries. If I upload the dates as plain text I have no issues. I have…
