-
Need Help with Formula, want all project summary sheet to record most recent step completed
Hi I have a summary sheet that contains all projects that my various PM are working on, the project summary sheet looks like this: Each project then has its own sheet for the PMs to keep track of what steps have been completed for the project, looks like this: On the summary sheet in the "most recent step completed" column…
-
IF THEN formula
I'm trying to incorporate a formula in one of my sheets. I'm going to use terms as if I were referring to Excel since I'm still getting familiar with the terms in Smartsheet. For example, if cell A2 contains a date but cell B2 doesn't have a date then I want the value in cell C2 to return "50%". If cell B2 contains a date…
-
How can I connect multiple sheets into 1 master sheet?
I have multiple sheets, each populated by their own form. I would like each sheet's columns imported into the master sheet and populate the same row. Is that possible?
-
Automate the Progress Bar
Hi there Smartsheet Guru's! Im trying to figure out the best way to automate a progress bar, based of 9 columns that all have check boxes. Screenshot shown:
-
Formulas for highlight the difference
I'm new and it would be great if I had help. I would like to know the formula that must be put in a cell to highlight if there is an equality or not between 2 values (see screenshots). I need to do it to highlight the differences during an inventory and highlight them (with the conditional form like "if this is False…
-
How to extract the data from the another sheet?
I am trying to find out the formula that help me to list out how many trading partners that we are currently working on it. The list should not be duplicated and it will be Renault, Titan X, Volvo. Can someone please help me?
-
Collect function feature add multiple columns
When using the Collect function inside the Index function a user must select a range of only 1 column or the error #INCORRECT ARGUEMENT SET is returned. This also means that the row_index of the Index function must also always be 1 as the Collect function is limited to return a single value (as opposed to an array of…
-
Nested IF troubles
I'm looking to do a NestedIF formula where I set up a predictive "Projected Ship Date" column to use additional columns to the below (old screenshot, but I figured it indicated appropriately enough). Not sure what part I have incorrect- but I am getting an #Incorrect Argument Set error. Formula I'm using: =IF([LNP…
-
Weighted Average - Employee Scorecard
I can't quite get this formula right. I'm attempting to create a scorecard where competencies account for 50% (all competency categories are equal) and goals are 50% (performance is 80% and development is 20%). The column is a drop-down but is not restricted to drop-down options. The formula I'm using is =AVGW([Employee…
-
Count if field is not blank and meets other criteria
I need help with a formula. I am trying to do a count of all of the fields where CP60 is not blank if the Check In is Initial Review of Plan and if the Month is 4 and the Year is 2023. I cannot figure out what formula to use here. Thanks!