Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template to view 100+ formulas, including a glossary of every function and examples of commonly used and advanced formulas.

❓️Product questions
Sign in and ask it here! The community's got your back.

📈 Wondering if there’s a problem?
Check out the Status Page and subscribe for notifications.

💡 Share your knowledge!
Help others by answering questions.

Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Formula
Hello, I am trying to find a formula that will allow me to have a count of running occurrences. For example, on the first occurrence of “A”, a 1 will show, then 2 for the second; 3 for the third occurrence, and so on. I know in Excel I can use COUNTIF, but when I try it in Smartsheet it returns the total number of…
Counting all children, including nested children
Hi - I think I have stared at this enough and tried many ways of sum and count formulas, but is there an easier way to count ALL the children of the highest outdented parent row which has multiple "sub-rows" with children underneath? I am trying to count the cells that are nexted beneath those rows and the children ()…
Can someone help me get a Countifs formula to work from another sheet?
I'm trying to get a countifs formula to work from another sheet. I've clicked on select from another sheet and copied the formula that works on the existing sheet but still can't get it to work. Here is the formula: =COUNTIFS({2022 Life Production}Rep:Rep, "Tim Crabtree", Status:Status, "Issued") The name of the other…
Any formula that can help me to calculate the number of the employee
Hi all, I am currently stumped by which formula to use in order for me to calculate the number of the employee. As you can see from the screenshot below, I was planned to calculate the movement of the employee in monthly basis. So, currently the formula that I using is: =COUNT([Joined Date]@row) - COUNTIFS([Last Working…
Value Lookup
I am trying to create a formula that uses that rows ID to look up on another sheet, if that row ID is used, to then use the info from the column. But I keep coming up with no match. =VLOOKUP([Project ID]@row, {Contractor Entries Range 3}, 7, false)
Nested Index/Match if Partial Text
I require a cross-sheet formula that will search for a Task (row) in another smartsheet, if the Task ‘Comment’ (column) contains the word “All”, then go to another Task row and index the Date. If the Task ‘Comment’ (column) does not include the word “All”, display the original Task Date. For example: If Task 4 Comment…
% Complete
I am trying to do a column where it calculates the % complete based on 4 other columns (that have to be completed in succession). Once a date is entered into these other columns then I would like the % complete to add 25% to the % complete. I was thinking I need to do an Multiple IF statement, but cannot seem to figure out…
Referencing Cells in Another worksheet in a workgroup
I am attempting to reference a cell from another worksheet and am getting prompted that I do not have permission. I am the owner of the master sheet. I am also the owner of the template the referenced sheet was created from. Both sheets are in a workgroup I created. How can I complete this action?
Hi, I am trying to calculate the number of incidents that have occurred in a month.
Using the following formula getting unparseable =COUNTIF([Date:Date], MONTH(@cell)=11)
Can I write a formula for past due calculation?
Hi, A formula is updated to calculate the Past Due as "=IF(OR(PARENT(Description@row) = "Summary", PARENT(Description@row) = "Instructions"), "", IF([Due Date]@row = "", "", IF(AND(Status@row <> "Complete", Status@row <> "Canceled", [Due Date]@row < Today#), "Overdue", "Not due")))" Hence in result it gives "Overdue" or…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

Updates to a sheet via form
I've seen several posts about updates to a sheet via a form or request an update via trigger. Here is my task... Create a sheet to track mileage for a list of team member for reimbursement. Information on the sheet needs to stay confidential. I need to update three different cells on a team members record on the sheet.…
Sum Formula containing keywords?
I'm trying to keep a running sum of the amount of liquid we are holding for our business's transfer log and I am not even sure where to begin! We have to log transfers (IN) and (OUT) and I would like to write a formula to keep up with this if possible. (Adding the amount in rows with IN and subtracting the amount in rows…
Could someone help me with this formula?
We are asking our managers to use SmartSheet to enter information about their employees (via the add form). Be are requiring them to enter the employee ID which has to be 9 digits, but many times they don't enter all the numbers. I read about helper columns to check whether or not the format is accurate and then send an…

Formulas and Functions

Help Article Resources

Categories

Popular Tags

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags