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.

Create cell reference based upon horizontal axis position
Is there a way to create a cell reference based upon a horizontal axis? For example, for a given column, I want it to always represent the cell directly to its left. For this example scenario, a new column will be added for every date and the new results will be entered into that column - Since the new date column will…
Developing existing formula
Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change Status]7 = "2. QA Rejected", [Post AFC Change Status]7 = "6. Returned by NR PM", ISBLANK([Post AFC Change…
How can I modify this equation?
I am running a report based off a request intake sheet that pulls the 1st choice date and 2nd choice date selected on a form request. This report will be put onto a dashboard and show only available dates (dates that have not been selected as either a first choice or second choice date on a form submission). I have created…
Why does this column formula doesn't work?
I have this formula I'm trying to convert to a column formula, but I get an error message. Any ideas why? Thanks! =VLOOKUP(Site@row; {Gestionnaires EPI Plage 1}; 2; false)
Help with month end formula
Hi, I'm building a dashboard to track referral responses. The missing part of my dashboard is I need create a formula that gives the total for each category by month and year. I can't figure out what function I need to add the the formulas I already have to break down the total by month and year. The formulas I've built so…
CountIF text string criteria by day, week, month
Hi Everyone, Wanted to provide a bit of a background before posing the question, I had set up an intake form which collects information of events. To analyze the raw data, I set up another worksheet to where I could keep all the formulas. In the second worksheet, I am trying to count the number of times a specific event is…
Does CONTAINS work with TODAY()
This formula is returning false even when TODAY() is in the value in the [Date1]@row cell. =IF(CONTAINS(TODAY(), [Date1]@row:[Date3]@row), "true", "false") The range [Date1]:[Date3] are formatted as a date columns. Does CONTAINS work with dates?
Count Multi Select dropdown values
Good evening everyone! I’m looking for some help with a formula for Multi Select drop down. I’m looking to reference another sheet and count or sum the number of values selected in a drop down multi list regardless of what has been selected.
I'm trying to count the empty checkboxes in a column if the neighboring column is not empty
I am newly certified and am looking for help with formulas. I want to count the unchecked boxes if there is something in the Action # column and do nothing if it is empty. What am I missing? =IF(NOT(ISBLANK([Action #]),(COUNTIF(Completed:Completed, =0)))) Many thanks, Michael
Adding IFERROR to AVG(COLLECT
Hi, I am needing to add an IFERROR to the following formula to return a "-" if no data is present. I attempted to use a few examples seen in other questions but it keeps giving an invalid argument. =AVG(COLLECT([FPY %]:[FPY %], Date:Date, AND(@cell >= DATE(2020, 11, 29), @cell <= DATE(2021, 1, 2))))

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