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?
Ask it here! The community's got your back.

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

I have a Move automation it disappeared from first sheet but didn't appear on new one
I had an automation that I created that had previously functioned. Basically the user check a box in a column and once the check box is selected the row is deletes in the original sheet and should appear in the new sheet. I'm a little concerned because I used the move command and it disappeared from original sheet and just…
VLookup help
HI. I need to look up a # based on the entry entered in one column. I have established a look up table, but having a difficult time with the formula. example - I enter ACME Supplies and I want it to look up the vendor number in the table and return the value into the corresponding field.
Is there a CONTAINS alternative for Contact formatted cells?
Goal: Count the number of times a name is mentioned. Assigned to is multiple contact column Name is a contact column =COUNTIFS({P & A - Assignments List | Assigned To}, CONTAINS([Name]@row, @cell)) Is there a CONTAINS alternative for Contact formatted cells?
COUNTIF
I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria. A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliverable Name], "Parent Project") I need to add two additional criteria for the same second range. I want it to also count if…
How do I remove duplicate rows if there is a duplicate in column 1?
My data has unique Job IDs but every time a row is updated in my master sheet it is moving it into another sheet creating duplicates. I want to delete the older rows and just keep the newly added row. How do I do this? Please help.
Why does Smartsheet treat 00 as a text instead of a number?
I ran into this the other day because of mistyping a number. I meant to type in 100 to adjust a number in an other column on the sheet. Instead I typed 00 and instead of adjusting the number from 460 to 560, it appears to have concatenated the 00 and changed the number to 4600. Has anyone ever seen this and is the a fix…
Help with revision of Nest IF Statement for Symbols
Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all aware, we are not always told about all the pieces of the puzzle. that solution was: =IF(AND(ISBLANK(Certify@row),…
check box and week days match
hi i'm worling on two tables, one to identify assigned days off per employee and another on to identify days off on a yearly basis. i'm looking for a formula that recognize the two days assigned on the first table and automatically check the appropriate box on the second table for all dates. thank you for your help.
Sum of only last child in cell range
Hi there I would like to count the values of only the last children in the column. Some cells have one indent, some more, so I would like to know the formula, to count only the last indent children. Below is an example what I would like to achieve. The result of the formula should be 350. Additionaly I would like to…
SumIfs Formula
Good day. I would like to add in my summary a formula, it is the sum of the revenue, not made, for each Month. So it it the JOB_VALUE column - to indicate the value of the job ACCOUNTS columns - to indicate if it was invoiced (Drop down column - 1. Invoiced 2. Not Invoiced DATE of job column - this contains a dates from…

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Popular Tags

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")
Formula Help
Hi All - I am hoping someone might be able to help me. I am terrible at formulas and I cant seem to figure out how to pull what I need on my own so I copied a formula from another sheet we have at our company. The issue is that it returns it multiple times. So the expected result is "four", the formula returns "four"…
Are You Able to Join Two Columns into a Data Shuttle Dynamic Dropdown?
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown column in a target sheet, without changing the source sheet. For example, I want to combine Num and Name into a format like…

Formulas and Functions

Discussion List

Help Article Resources

Categories

Popular Tags