-
counting multiple select column
Hello, I have a project plan that I'm trying to report on. I have a column for health check and a column for assigned team. I want to see a total count of each status per team. That is the easy part and I figured that out by doing a =COUNTIFS({HealthCheck}, "Red", {Team}, OR(@cell = "FI", @cell = "FIT")) My issue is that…
-
Time to Complete a Task Less Time Wasn't In Lab's Possession
Hello all, I am struggling to get this formula correct for "Lab Time to Complete" column. Here's what I need to have done. I believe it's possible, but I keep getting errors and think I may be quite a ways off the mark. If "Destructive Testing Pending Days" and "Third Party Pending Days" are empty, find networkdays between…
-
Is it possible to only copy certain cells with automation?
We have a Master Task Order list which contains a multitude of data for a single project. At different stages of the process, parts of this data are copied to multiple other sheets. Is it possible to set up an automated workflow that would copy only specified parts of this data when criteria is met? I.e. select which…
-
IF formula to Assigned To
I am having trouble trying to figure out the formula based on the example: If the ISSUE TYPE is PTO, then assign it to XXXX. I have one column labeled "Issue Type" with a dropdown selection, and the other column labeled "Assigned To". Please help!
-
% Complete Average Column Formula
I am currently using a Column Formula to calculate % Complete. The formula is a combination of two checks: Children rows calculate based on a check box "Complete" column. The % complete will be calculated as 0% for an unchecked box or 100% for a checked box in the Complete column. Parent rows are designed to calculate the…
-
Red / Yellow / Amber formula
Hi, Can anone please suggest for my sheet that is formatted as shown in the attached image and for the following conditions if risk/issues cell is not blank and due date is in the future then yellow if past due date then red if past due date and with risk/issue cell not blank still red if not past due date and no…
-
substracting empty cells gives #invalid operation
column 1 & 2: data, column 4: data column 3: =IF(SUM(column1@row:column2@row) = 0, "", (SUM(column1@row:column2@row))) so if column 1 plus column 2 equal 0 the cell stays blank. this part of the function works well in column 5 i want to substract column 3 from column 4. if column 3 is blank (aka hidden 0) i get an error…
-
How do I count occurrences of a word in a row?
I'd love to count the number of times the word "below" occurs in a row. Apologies for the simplicity of this question, I'm very new to Smart Sheets! This word could occur as either "below target" or "significantly below target", but I'm hoping just to count ALL instances of "below" once if that's possible. I've tried…
-
List one sheet to another when column contains text
Hi Smartsheet Guru's I have a sheet with many columns and formulas - which is increasing in size and slowing down. I would like to offboard some of the formulas to another sheet. Therefore, I would like to create a formula that looks in column Gap ID and if it has text (not empty) then the formula would copy the text in…
-
Partial Text Search in Range - Index/Match
I have searched for solutions and getting weary. Challenge find PO# (a 6 digit alpha-numeric) in a string of text (GL_Remark on another sheet to index the actual value cleared general ledger. I had this formula working in Excel: =INDEX(General Ledger_AmtPaid,MATCH("*"&[@[PO/INV]]&"*",GL_Remark,0)) In SmartSheet Only finds…
