-
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,…
-
IF::Then reference separate sheet
Hello I have (2) sheets I am working on. One is my Main_Running project sheet. The 2nd, I would like to populate depending on whether a column in the Main is "starred" If Column_is_starred; then I want it to pull in information from a separate Main_sheet column. I would like the 2nd sheet to only be populated if/when the…
-
INDEX(COLLECT - #Invalid Value Error
Good afternoon everyone! Looking for some help with INDEX(Collect. I have a main sheet set up and also have created a helper sheet. Once the install date on the main sheet is changed, automation copies that row to the helper sheet. I want to see on my main sheet the previous install date as well. This I've figured out. I…
-
Help with multiple IF ISBLANK statements
Hi, I am trying to list values, comma delimited, from a number of columns based on if the previous column is blank. So for example, based on this table: Object Code 1a Object Code 1b Object Code 1c Object Code 1d Object Code 2a Object Code 2b Object Code 2c Object Code 2d Object Code 3a Object Code 3b Object Code 3c Object…
-
Help with IF + MAX formula with OR
Hi, I'd like to make a formula for the following purpose: We have daily quotas that need to be reached, however it changes depending on the day. Monday through Thursday the goal is 3, and Friday the goal is 1. I'd like an IF formula to do a MAX operation depending on the day. This is so that every day we can see how many…
-
If Then Help
If a cell in Column A (titled Job) equals Marketing (from drop down in Column A), then adjacent cell in Column B (titled Responsible) equals Susan (name from contact list). I want someone to choose from a drop down in Column A, then based on their choice a particular person receives an email. Column A is set for multiple…
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
IF Formula
Hi I would like help on a formula to score time criticality. Ive tried the below but its coming up with errors. I also would like to add a formula that if there are any negative numbers such as -201 then this would show as "10" Formula i used below but not working =IF([Time Criticality]@row <= 30, "10", IF([Time…
-
Issues with Convert to Column Formula
Hi, I have a column that I'm trying to convert to column formula but won't because "The column formula syntax isn't quite right" and gives me Smartsheet's help article for more information. The column's type that I'm trying convert is "Symbols" and is the Progress Bar. The Formula of the attached example is: =IF([RPM %]851…
-
Hi team, may I have help with the IF formula below?
=IF([Rank]@row = "1", [Request Date]@row + 5,""), IF([Rank]@row = "2", [Request Date]@row + 7,""), IF([Rank]@row = "3", [Request Date]@row + 9,""), IF([Rank]@row = "4", [Request Date]@row + 11,""), IF([Rank]@row = "#NO MATCH", [Request Date]@row + 11, ""))))) I'm trying to add an IF formula based on the rank column and…
