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.

Two date columns - need to take the earlier date of the two and add 10 years
Hello! I am hoping for some assistance with nailing down this formula so that it displays 10-years on top of the earlier date from two columns. I found a prior community post with the below formula, but I just can't seem to get it to work the way I want it to. =IF(AND(ISDATE([Last AF]@row), ISDATE([Last BIR]@row)),…
I need to calculate the networkdays between 2 fields including when the end date is blank.
Column 1 titled "todays date" - this is the date the item is submitted Column 2 titled "manager response date"- this is the date in which a response was provided Column 2 may be blank. - Therefore in this case I need a formula that will show me the networkdays from the "todays date" column and consider Column 2 as a 0…
How to Identify New Rows Added by Data Uploader on Pivot Sheet
Hello - We load a large amount of data onto several sheets via the Data Uploader and Pivot apps. Looking for a way to identify newly added rows from one upload/pivot process to the next. We can handle this on the source data prior to the upload process, but hoping to make the process within Smartsheet to save some steps.…
What is the nested IF formula for the following?
If a request is less than 70% complete, turn the "Status" column into a "Red" status ball If a request is 70% or above and less than 100% complete, turn the "Status" column into a "Yellow" status ball If a request is 100% complete, turn the "Status" column into a "Green" status ball
IF, THEN formula that references a checkbox field and a date field
I'm trying to write an IF, THEN formula that references a checkbox field and a date field, but I keep getting errors. Here's the logic: If the 'EMDS' column is checked, then calculate the 'Date Needed' column minus five days. If seems simple, but it may actually be too complicated for the system since it essentially…
Multiple IF/And statements in one column
I am using the function: =IF(AND(Impact@row = "Low", [Angela Approval]@row = "Approved", [Billye Approval]@row = "Approved", [Jason Approval]@row = "Approved", [Michael Approval]@row = "Approved", [CAB Approval]@row = "Approved"), "Approved"), IF(AND(Impact@row="Regular",[CAB Approval]@row = "Approved"),"Approved") When I…
Automated date due to change in dropdown list
Hi folks! We're trying to set up a sheet where we are able to automated fill out different date columns due to a change within a dropdown column. If entry of the status dropdown is changed to pending, the current date should be displayed in the Date Pending column and - important - being locked for any changes. So that if…
Can I create a variable? Or two?
Hello, I'm working through some quotes for a project. In this project there area series of wall panels, in a series of locations. The material per sqft costs $X and the installation labor costs $Y per sqft. I have two cells in a hidden column that hold these numbers (should I have to edit it them later). Since the panels…
I am trying to create a Dashboard that will collect Vendor expirations ... 60 Days, 30 Days, Expired
I do not know the formula to create the answers. Can anyone help?
Collect and display nearest dates
I have a job tracker designed to track the art components of our jobs. We would like to have a column display the next nearest due date for that row. My trouble is we may have 1-10 due dates on a given row and there are non-date columns between each of the due date columns. I'm fairly sure I need to use a MIN(COLLECT( type…

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