-
How do I get the row ID of the first row of a sheet?
Is there something in the Smartsheet APIs that I can get this information?
-
Adding children with 2 conditions
Trying to count if issue type = defect and status is new or in progress Keep getting an error =COUNTIFS(CHILDREN([Issue Type]@row), "defect", CHILDREN(Status@row), "New", "In Progress") Incorrect argument
-
Why can't I convert this formula into a column formula?
Hello, I have sunk quite a few hours into trying to figure out why I can't turn the formula below into a column formula. Does anyone wiser than I have any ideas? =IF([Start Date]2 > TODAY(), "Blue", IF(AND([% Complete]2 < 1, [End Date]2 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green"))) The formula…
-
New User - Help With Formula!
I need help, I need a formula that brings me a value if it changed in the month before my update. If the value has not changed bring the same value. So, I need the formula in column "N" that bring the month before value of estimated final cost if changed, if not changed bring the same value. The problem is the column "M"…
-
Combining IF Statements is not working with comma
Hello, My formula is as follows: =IF(AND([日付 Date]@row < TODAY(), CONTAINS("1号室 Room 1", [問題報告RV東照明 Reporting Issue RVE Lighting]:[問題報告RV東照明 Reporting Issue RVE Lighting])), "Red"), (IF(AND([日付 Date]@row <> TODAY(), CONTAINS("2号室 Room 2", [問題報告RV東照明 Reporting Issue RVE Lighting]:[問題報告RV東照明 Reporting Issue RVE Lighting])),…
-
How to enter specific text if the cell contains a partial match?
My If statement: =IF(OR([Task Name]@row = "Discovery", [Task Name]@row = "Analysis", [Task Name]@row = "Build", [Task Name]@row = "Test", [Task Name]@row = "Deploy", [Task Name]@row = "Design"), "PMO", IF(OR([Task Name]@row = "PER", [Task Name]@row = "PRT", [Task Name]@row = "CK1 RTS", [Task Name]@row = "CK2 RTB", [Task…
-
Unparsable on Avg Collect
Good evening, all! You know those times when you've looked at something for so long and it eventually starts to blur together? Well, that's where I'm at, and could really use your help with this formula. In the A16 sheet summary field, I'm trying to bring in the average of the age column where the following conditions are…
-
If and when..
The thought process is a have a column with Multiple drop downs. If Service is selcted I would like it to take the date column and add a six month date for followup. The formula I was thinking is: =IF([What work type was completed?]@row, ="service", Date@row + 180, blank) However, I must be missing something. UNPARSEABLE…
-
Same Column - Row Type Header = Sum value of Row Type Detail
Based on the image below There are two Row Type: (1) Header and (2) Detail. JE REPORT is the grouping of these records. AMT = free form data entry Debit = if(AMT>0, AMT, 0) Credit = if(AMT<0, AMT,0) Question: I want to sum Row Type = Header for all Detail rows of the same JE REPORT. The first row would sum of RowNum 00074…
-
Referencing a range of cells in another smartsheet
Hello, I'm using the COUNTIF function to count the number of "Pass" in a range of cells in a separate smartsheet. I need to count the same items and cell ranges in 50 different smart sheets. For example, I need to count how many "Pass" are in a column called Test Process in the China smartsheet between rows 2 and 71. I…
