-
Test if cell contains value from list
I have a task list that includes tasks by customer name. Due dates are formula-controlled by an offset from an entry date. Certain customers of ours receive "red carpet" treatment, which requires me to recalculate the due date manually. I would like to try the following automated solution: Maintain a separate sheet with a…
-
Formula for Counting Checkboxes in a row
Is there a way to count the number of checked boxes in a row with multiple columns?
-
Autoupdate Formulas based on user entry
Hello! this is my first post and I would appreciate help. I want to setup a cell (call it "Cell1") on a row that is empty until a different cell ("Cell2") is clicked with a checkmark; upon Cell2 receiving the checkmark, I want Cell1 to autoupdate with the present date. Is that possible? thanks!! CVM
-
Link between two values (in 2 different columns)
I've created some values for my "status" column (In Progress, Delayed, etc.) and I've created some symbols to match these values (green, red, etc.) in another column. I use both. I'd like to link those values, ex. : if I choose "In Progress" in column A, then the green symbol will automatically appear in the column B. How…
-
Applying formula/conditional formatting to an entire column + hiding the column
Hi all, I am using the LEN formula in one column ("EN title character count") to show the number of characters in another (column "EN title") then applying conditional formatting to this column ("EN title") to show as bolded and red when the character count is greater than 80. This works perfectly, but I'd like to be able…
-
Nested IF/AND Formula
Hello I am trying to create a matrix using the IF/AND Formula. So far the first part of the formula works which is this: =IF(AND(Probability1 = "Low", Impact1 = "Low"), "Low", IF(Impact1 = "Medium", "Low", IF(Impact1 = "High", "Medium") Now I want to add the other combinations ((Probability1 = "Medium", Impact1 = "Low"),…
-
Formula help
I have a request for time off form, when a request is submitted the person is notified that if they do not receive a response within 5 business days they can consider this approved, however I would like to create a formula that is based off the auto created date so if Approved column (where supervisor notes if it is…
-
Referencing checked state of Flag symbol using formula
I want to use a Flag column to mark high-priority tasks and calculate a reduced lead time. In a Due Date column I use a formula to add 7 days to the Received Date. I want to change the formula so that it adds only 5 days IF the flag is checked. I can't seem to find out how to reference the value of the flag cell, though.…
-
CountIF "No" or Blank
Hi Smartsheet community, Trying to create a formula that counts the number of cells that are blank or have "No" in them. It is a dropdown column with only two choices, "Yes" and "No", so I tried =COUNTIF([ColumnName]:[ColumnName], <> "Yes"), but that gives me 0
-
parent $1 less than the sum of its whole number children
Does anyone know why a parent would be $1 less than the sum of its whole number children?
