-
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!
-
Can multiple form entries populate one row?
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 end time of the same delay. Is it possible to have multiple entries populate the same row so the team lead doesn't have to…
-
Can you help me finding my syntax error?
=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évue de l'événement@row] is equal or less than 5 days before the event, then "Rouge", If Statut@row is "Terminé", then…
-
Date+days not calculating correctly
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 Start Date]@row)) + 21) I receive an #INVALID VALUE If I hardcode the date into the formula (=DATE(2023, 10, 15)+21, I return…
-
Multiplying where a field may be blank
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 Operation now. Would "if error" fix this and if so, where would it go? =IF(ISBLANK([1455 MU Gallons used]@row), "", IF([1455 MU…
-
Link two cells
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 column "Status da entrega" to "Aprovada", the next line change "Status da atividade" to "Liberado" and it is working fine with…
-
Email automation with PARENT/CHILD data from pivot table
I'm trying to create an output of specific rows of a pivot table to attach/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The "Alert someone" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…
-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
