-
formula help
hello all, can I get help with this - I am trying to count the "√" in column DAY 2 but its in a children lines from parent line 03.2025 - that is a children's line for parent line 2025 I don't know what am I doing wrong =COUNTIF(CHILDREN([DAY 2]:[DAY 2] "√"))*8.5
-
Partial Formula Working
Hello, Everyone. I have a commission sheet with many columns, and I have a 3 part formula to calculate commission based on 3 different % depending on which month of the contract the sales team is in. The first two IF statements work beautifully. The 3rd part I need to calculate that if the Month of Contract is greater than…
-
Level 1 Net Days
Hi what column formula can I use in days to sell that calculates the number of days between start date and date marked sold that calculates only on the level 1 main level. I do not need it to calculate the children.
-
Formula for capturing one line of text only
Hi all! I am pulling a report from another system into Smartsheet. One of the columns allows multiple entries in the system that generates the report. If they enter multiples, each appears on a separate line. I just want the top-most entry to pull into a helper column. I am using this formula: =LEFT(Column@row,…
-
Please Add a Sum Product Formula
Please add a sum product formula to improve ease of calculations without workarounds.
-
Need to bring data from another sheet based on 2 fields matching
The formula below must be mising something that I can't quite get. Goal: If the 2 cells combo of the row data on the current sheet are found on either of the other two sheets, then bring back the data from the request ID column from the match found on the other two sheets, or blank. =IF(OR(COUNTIFS({Sheet1 - E#}, [E…
-
Getting #INVALID DATA TYPE when using the MONTH and YEAR commands
My source sheet is using this formula in the 2025 MAR column: =COUNTIFS({Christine Test Sheet CLLI Code}, CLLI@row, MONTH({Christine Test Sheet Acq. Cut Date}), 3, YEAR({Christine Test Sheet Acq. Cut Date}, 2025)) on this source sheet: My destination Sheet that the source sheet refers to i.e., {Christine Test Sheet Acq.…
-
Extract text from one cell to populate the assignee cell in a Smartsheet recognizable contact?
I have a challenge i have been racking my brain on for a while. I want to extract names from my ACTION ITEM cell that will update the ASSIGNMENT correctly instead of just a text string. I am using the =MID, FIND ":", LENS, FIND ":" to extract & populate the HELPER COLUMN, but then want to make sure that the ASSIGNEE will…
-
Help with the following parent/child formula
=COUNTIFS(CHILDREN([Not Applicable]@row), 0, PARENT([Name of the Operational Provision or Rule],"Payer-Accounts") #INCORRECT ARGUMENT SET I am trying to count child rows where a checkbox is set (not applicable) where the parent row title is "Payer-Accounts". I am creating individual Summary values for each of the parent…
-
Automatic numbering for Work Breakdown Structure
Does anyone have a formula so a WBS will automatically number up to five levels? This doesn't seem like a standard feature in Smartsheet but is critical to our projects.