-
Formula Help - Check the box once per unique ID
Hello - I will try my best to explain my formula question. I am using DataTable to import a few hundred to a few thousand rows of data monthly into a targeted sheet. After 180 days from a specific date column, they roll off the targeted sheet. My goal is to show the Unique Rows like the "delete duplicate" functionality in…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
-
Is there a formula or other way to have a column display the date that a checkbox was checked?
Is There A Formula or Other Way to have a column display the date that a checkbox was checked? I'm also wondering if the user who checked the box could also be displayed in a column?
-
Metrics NOT updating periodically as expected
Not sure if anyone is experiencing this. I've created a METRICS sheet for every project that sums up counts for Task Health in order to present on Dashboard through Graphs. I'm noticing that theses metrics are NOT automatically updated unless I refresh the page a dozen times OR re-write the exact same formula again. But…
-
Dynamic "UNIQUE" Function
Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it…
-
"Invalid Data Type" Error - Need Formula Help!
I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank. =DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date…
-
COUNTIFS
Good afternoon all!! First time poster on here and still learning my Smartsheet. Stumped on the formula and looking for some assistance. I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed. What I am trying to do is count it each column for each similar column for the…
-
Cross sheet formula to pull in value
I am trying to write a formula that looks at another sheet, looks at 1 column if the column is NOT equal to 0 then it would pull in a different column's cell information. =IF(INDEX({Job Intake Form - Fence Range 1},1){Job Intake Form - Fence Range 2}>0) This is what I was thinking {Job Intake Form - Fence Range 1}…
-
Formula to calculate a total of how in a column year to date
I want to count how many have been hired A220 in the below year to date The formula I used: =COUNTIFS([Date of CJO]:[Date of CJO], @cell <= TODAY(), [Date of CJO]:[Date of CJO], @cell > TODAY(-157), Fleet:Fleet, "A220") and =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date],…
-
How to count how many are in the last 7 days
I am trying to count how many cells are in the last 7 days The formula I used is: =COUNTIF([Avature Application]:[Avature Appication], AND(@cell<= TODAY(), @cell > TODAY(-7)))
