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.

What is wrong with my IF formula
=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required" ,IF([Transportation Type]@row=”Train”, "CWT Code Required")))
Current vs. Next Due Date
We have a list of software/hardware/contract obligations. Currently it is setup to provide 30, 60, and 90 day reminders (based on current the due date) to the interested parties so our contracts and licenses do not expire. I am wondering if there is a way to update a renewal date for the following year once it has been…
Count if the cell in two different columns is blank
I am trying to do a conditional count if 2 columns from the same spreadsheet is blank. Here is the formula I am using that is coming up with an error message. With Column 1 being CT BAY and Column 2 Being Range Baylor. In other word if both these columns are blank then to count it. This is the formula I am using am I doing…
IF(OR formula for a Checkbox
I believe this is simple, but I am #UNPARSEABLE error. I have 5 approval columns with Approved, Denied or Received. I want to check all 5 columns, if any one of the columns has received, then select the checkbox. Here is what I have now, what's missing? =IF(OR([Approval1]@row, ="Received", [Approval2]@row, ="Received",…
I'm stuck trying to do some basic arithmetic using the YEAR function
I'm trying to derive the number of years that have passed since a boat was either built or underwent a major refit. I have one column for date built and another for date of last refit. First, I wanted to return a blank if there is no last refit date, and then to calculate the number of years since the last refit if there…
How do I combine the following formulas?
=IF(LEN[Cardholder Employee ID]@row = 9, "Yes") =IF(LEN[Cardholder Employee ID]@row <> 9, "No") Or how to count the number of numerical characters in a cell? the count is not working for some reason Sandi
Using OR with COUNTIF function
I have a sheet with a "Start Date" column and a "Completed Date" column, and I am trying to get the month end count, meaning it was either started OR completed in September. Both columns are formatted as "Date" columns. Can anyone help me? Thank you! -Erica
Alert Me When A New Sheet Is Created
Hi there, Is it possible to create an alert, that when someone in my team ads a sheet, I as admin should get notified?
Form Logic, Restrictions & Evaluating
I'm building a Form, and one of the criteria is Budget. I would like to evaluate the Budget field as they tab-off of it, before the form is submitted as I know there would be times people will enter an amount that won't be sufficient. The scenario would be - the Budget is $1,000, but based on the number of calendar days, I…
Formula not populating certain rows
Hi everyone, I'm seeing an issue where I have a particular formula that moves a date to the nearest business day if the original date lands on a weekend. However, when I drag the formula down the column, it will not populate certain cells. (This is actually apparent across the entire row). Would you know how to solve this?

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