Formulas

Hi, This is our current formula for our progress bar: =IF([Deployment Date]@row = "Cancelled", "", IF([Deployment Date]@row = "", "", IF(OR(COUNTIF([Copy Status]@row:[Code Status]@row, "Delivered"), COUNTIF([Copy Status]@row:[Code Status]@row, "--- N/A ---")) >= 4, "Full", IF(SUM(COUNTIF([Copy Status]@row:[Code…

February 09, 2026 Users can now view the history of any formulas entered into a cell using the Cell History feature in table view (an improvement over the current grid view experience). Learn More Environments availability: Commercial US, Commercial EU, Commercial AU Plan availability: Pro, Business, Enterprise, Advanced…

Hi Everyone, I’m looking for best practice recommendations for managing multiple Smartsheets that are connected across different projects and management reporting needs. Currently, I have several sheets linked together using formulas, which works, but I’m wondering if there is a more efficient or scalable approach. The…

Hi everyone! I’m Jonathan from Boise State University (Boise, ID USA). I’m currently looking for advice and best practices on transitioning our department's budget reporting process into Smartsheet. Current Workflow & Challenges: Data Scale: We pull data from four different Excel documents, using Power Query and Power…

Have the option (not compulsory display) to convert the predecessor column "7SF-2d" to a text like "Complete 2 days before line 7" or another option if chosen "Complete 2 days before Task7" adding the name of the task. I want to emphasize the choice here so 2 formulas would be better than a changed view like in the…

Created a formula to send an email to john doe if AMER or EMEA or APAC is selected in georgraphical region and send email to Jane Doe only if EMEA is selected and send emial to Bill doe only if APAC is selected. See formula below. I'm receiving column forumla syntax error. =IF(OR([Geographical Region]@row = "AMER", "EMEA",…

I have two sheets that have test results Oil PF(1) and Oil PF(2), I have made helper columns for both of them using =MAX(COLLECT({Oil PF(1)-Date}, {Oil PF(1)-Circuit-ID}, [CB Identifier]@row)) for both respectively. they only return blanks, and I cant figure out what is going wrong.

Hello, I am new to smartsheets and I have go through the on-line training. I am well versed in excel so I have some knowledge of spreadsheets. One thing I am perplexed on in smartsheets is I can't seem to find a formula to search all the sheets and then return a value to sum. I have used the SUMIF and pointed to a cell to…

I have a maintenance sheet that summarizes budgets and pull the latest week's worth of data that is available. The budget buckets are a set of 8 numbers (ex: 12345678). Some buckets start with zeroes (ex: 00123456). I had to build a workaround with another field instead of referencing the 00123456, and I'd love to know if…