-
Count 1 row and get an average based on a score in another row
Hello, How can I use this function that I know in Excel, but in Smartsheet? =SUM(J1:J5)/COUNTA(I1:I5) J - column( scores ) = either a 1 or a blank cell I - column = customer service Thanks
-
Help with COUNTIF formula
I am trying to write a formula that will automatically fill in the checkbox IF another checkbox cell is also checked. Here is the current formula I am using. =IF(COUNTIF([Repair Doors Needed]:[Repair Doors Needed], [Repair Doors Needed]@row) > 1, 0, 1) The weird thing is, this formula works on some of my sheets, but…
-
Nested if returning cell value
Hi All, I'm trying to create a nested if that will bring back the value of another cell if true. I can make it work in Excel but when I try to recreate in Smartsheet, I'm close but not quite there: Excel Formula: =IF(I8="Invoice Reconciled",0,IF(I8="Work Not Started",0,IF(I8="Completed/Not Invoiced",H8))) Smartsheet…
-
Looking for help with nested IF and FIND
I'm looking to return text based on the content of a single, fixed cell, but I believe my syntax is bad. Column A, Row 1 could potentially be "Q3M1W1", "Q3M2W1" or "Q3M2W3" which would be entered manually by the user. I would like to have another cell display "M1W1" if A1 is "Q3M1W1" or "M2W1" if A1 is "Q3M2W1" or "No" if…
-
How to calculate weekly GP on a gant chart?
Hello All - I dont believe this is possible with smartsheet - but I want to make sure before I purchase a one off. I have included a screen shot below to illustrate my goal. This screenshot is from a colleague who uses FastTrack for this one and only purpose. I currently have a master schedule that shows all of our…
-
Sum of all descendants
Hi I am trying to add a formula to get the sum of all descendants. I have used =SUM(CHILDREN()) but that only adds in direct children. I need to also be able to add in the grandchildren, greatgrandchildren, etc. Any way to do this? thanks
-
How to configure a project assignment and the assignment date and show the rest of the fields diseab
I have a problem. When Smartsheet sends the form on request to an area. I need to know if after receiving a project from a form, to be able to assign a resource and the date of assignment I can only do it from an update? or there are other ways of being able to assign people and date of assignment, automatically without…
-
Troubleshooting with IF AND formula for the automation of RYGG values
Hi Everyone, I am using a sheet too manage and track mails received by my department , and I am having troubles defining a formula to automatically display in a symbol type column ( called Statuts ) , a ball whose coulour depends on some circumstances . I would like to precise that I am using the French version of…
-
formula to turn red flag on at risk column on set no. of days before Completion Date
Hello. Please help w a formula to turn the red flag of the 'at risk' column for various number of days before the date set in the Completion Date column. Thank you. Dan
-
I need help creating a formula for identifying task status
Here is the formula I'm using... =IF([End Date]56 > TODAY() + 7, "Future Task", IF(AND([End Date]56 < TODAY() + 7, [End Date]56 > TODAY(), [% Complete]56 < 1), "On Schedule", IF(AND([End Date]56 < TODAY(), [% Complete]56 < 1), "Late", "Complete"))) The formula works to identify Future and Late tasks. How do I update the…
