Formulas and Functions

Archives for July 2022

Automation triggered copy one cell to another on same sheet
Hi , I would like to be able to "check" a box in col A which will trigger a copy of the content in col B to Col C (but not change value as long as the checkbox is checked) I want to use this to flag a specific line/task as one which is due data is important for me so I want to copy it to a column "important dates" but the…
Sheet Templates - Workflow Update Requests
So we want to set up some templates that we will be able to use over and over when a new project comes on. In this template, if we create workflows for update requests, will these start from the "as of" date from when we begin using the template or will we need to go through and update the workflows each time? For example,…
Summing a Multi-Select
I'm trying to figure out an easy/dynamic way to sum a column. Right now, I have Column A in Sheet 1 that is a multi-select. I want to lookup the result of that multi-select in Sheet 2, and total the values from Column B. So I know how to do it manually (i.e. - by spelling out all the values using FIND () or HAS ()) as part…
COUNTIFS AND HAS functions for Multiple values
Hello, Need help on this, I need to get the total number per tasks and status in Summary Sheet, resource is Sample Data. Tasks, Assigned Office, Assigned Field (in Sample Data sheet) has multiple values Thank you!
How to include a newly inserted column in an existing formula?
I have a formula at the end of a row that adds everything to the left. I want to insert a new column and have it automatically included in the formula. Excel does this by default, can smartsheets do the same?
Can you skip a row and still use Column formulas?
Hi! I've got this sheet where all columns use the same formula except for the first row which is a kind of "header" and is a text row, if a use column formulas that text is erased, I was wondering if there's a way to use column formula and skip that row. The formula I'm using is =SUM(CHILDREN()) but every time a create a…
COUNTIFS Errors
I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls within a given month/year range. This one seems to be working... I think: =IFERROR((COUNTIFS(OTD:OTD, OR(@cell = "Yes", @cell =…
Nested IF with IFERROR
I have an IF statment that is working fine. But in many cases it is returning '#INVALID DATA TYPE'. When it returns that I would like the cell to be empty. How do /where do I nest the IF with the IFERROR?
How to put a value for each item in dropdown list
I have a dropdown list and I want to put a value for each item (but not in the list): Not Ordered = 0% complete Ready to Order = 1% complete Order Process = 20% Shipped = 50% complete In Country Customs = 80% complete Delivered = 100% complete Cancelled = 100% complete This is to help me to calculate the task % complete…
Is there a formula for this?
So I am needing to have a column decrease - (QTY) - for every "crtl+enter" line - (NOTES) - of the following cell. Is this something that is possible, or do I need to change my notes column?

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Trending in Formulas and Functions

If formula for multiple check boxes.
I have multiple columns with check boxes and I need a new column that validates if ALL are checked. I'm trying to create a formula that says: if column 2 is checked, AND column 3 is checked, AND column 4 is checked, 'yes' else 'no'. Any help is appreciated.
Formula IFS return values from other columns
Hi, i am trying to set a new column that should return EAS or ETS text depending of what it is in column named "ETS", but i want to add another if that return a value from column "Business Dropdown" if the column ETS is blank. This is the formula that i wrote now very simple and it is running well, but it is missing the…
Formula Help For Multiple Tags Within The Same Cell
Hey All! First time posting... so here goes... I am attempting to write a formula that references another sheet, looks at a specific column, and then 'finds and counts' all the instances of a specific tag. For example, the intake form allows multiple 'characteristics' to be chosen when describing a call. These…

Formulas and Functions

Discussion List

Help Article Resources