Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
Sign in to ask your formula question or join a discussion.
Check out a list of all the available functions in Smartsheet.
Download the Formula Handbook with 100+ formulas and in-sheet examples.
An article with frequently used functions and additional resources.
Hi Community, Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs. The new Formula Handbook is here to help formula beginners and pros alike. This template contains: * A glossary of all…
I have a master sheet with promotion applications linked to a SmartSheet form. Each applicant is identified by a ID number. There is a second sheet with the managers evaluation form. I don't want to send an update request or approval. I then want to copy the cells from the managers evaluation back in on the same row as the…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all! I'm trying to use an index collect formula to reference 3 different name columns, and use a range from another sheet to populate their employee number. I want the employee number to populate based on what is entered into any of these 3 employee name columns. The formula I've been trying is, =INDEX(COLLECT({Non-…
Hello everyone, I'm working on a project sheet (with dependencies enabled and the Gantt view) and I'm looking for a way to exclude canceled tasks from the automatic calculation of the % complete on parent rows. My requirement : When a child task changes to “Canceled” status, I want it to no longer be included in the…
Hi Smartsheet Community, I hope you are well. Just wondering if there is anyone from Smartsheet available here? I've raised a support ticket, case number 09376810 on 04 June 2026 and I've not received any reply on that. Basically, I am trying to move some rows to another sheet into the Workflow → Move Rows → Move to,…
I am looking identify a records position within a count. Meaning if I have a CountIf that comes back 10 records I would like to know if I am on the 1st record or the 5th record.
I'm building a "Top 4 Critical/High Priority" tracker on a dashboard sheet that pulls overdue items from a RAID Log using INDEX/MATCH/SMALL/COLLECT. Here's my current formula: =IFERROR(INDEX({Task Title Ref}, MATCH(SMALL(COLLECT({Due Date ref}, {Due Date ref}, <=TODAY(), {Priority Ref}, OR(@cell = "2-High", @cell =…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…