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 thos…
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 t…
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", "…
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 li…
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…
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 =COUN…
How can formulas be run against all Descendants of a Parent row, rather than only direct Descendants (Children)? Example: =SUM(DESCENDANTS()) Thank you.
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the proper…
I have a column with specific criteria (Sample type) and date column. I have another formula that looks specifically for a "sample type" and specific "factory". The formula I've used for this is: =COU…
