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. Ca…
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…
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). …
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 developmen…
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…
Use case: A team lead submits a form reporting a start time for a delay in work, giving information about the delay and crew members involved. Later, the team lead submits another form reporting the e…
=IF(AND(Statut@row <> "Terminé", ([Date prévue de l'événement@row] <= TODAY(-5), "Rouge")); IF(Statut@row = "Terminé" ,"Vert", "Jaune")) What I want is: If Statut@row is not "Terminé" and the [Date pr…
Hi all, I need to add 21 days to a date referenced in another cell. Ex: 10/15/23 When I use this formula: =DATE(YEAR([Projected Start Date]@row), MONTH([Projected Start Date]@row), (DAY([Projected Sta…
Hi! I am multiplying 3 columns + multiplying the next 3 columns to get a sum of the total cost. However, here is an instance where "1455 REP Gallons Used" is blank. I am getting the old Invalid Operat…
Hello everyone, I'm new working with smartsheet and seeing that he does not have all excels formulas. I need to change a "status" when I change a number in a column. For example, when I change the col…