-
Lookup returning no results
I am trying to have a LOOKUP formula return a result based on the status of a checkbox. I have tried to forms - one by having it look for "0" and one by creating a secondary column that reads the checkbox and returns a "Complete" or "Not Complete" status. Neither will return a result. I have attached a screenshot here…
-
How to calculate schedule % updates in Smartsheet
Hi, I use smart sheet for tracking my project progress. i would want to add one more column similar to % complete to calcuate my schedule percentage based on the number of days complete till date divided by duration. i added a column with percentage updates as per schedule however, these percentages do not roll up to the…
-
% of children
Hi, I want to calculate % of checked children in the sheet below, can anyone help me? https://app.smartsheet.com/b/publish?EQBCT=41482d287b58426b801642f8c4cd31f0 Niclas
-
Countif Tasks are completed late?
Hey There~ I'm trying to count how many of my tasks are being completed late and I'm struggling to do this. Here's what I got: Here is the formula: =COUNTIF([Completion Dates]:[Completion Dates], >[Due Dates]:[Due Dates]) This returns zero but I want it to return three. However, =COUNTIF([Completion Dates]1, >[Due Dates]1)…
-
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"),…
