Formulas and Functions

Archives for September 2022

#UNPARSEABLE error
Hi everyone, I'm having a problem with one of my formulas. Indeed, an error message appears and I can't solve it. My formula : =IF(OR(JOIN(COLLECT({S1}; {QRQC Date}; Date@row;{QRQC Area};$Area$1);"") = "", Weekday@row<> 7,Weekday@row <> 1 ,{S1}="/" ,{S1}="\"),1,0) Thanks, Léa
Adding row values based on date
Hello Smartsheet Community, I am trying to create a reconciliation system in Smartsheet for the on-hand count vs the dispensed count of an item. The idea is to have the end user submit a morning count of 3 different products every morning. Through another form, submit a dispensed amount for the products throughout the day…
Index match Help on formula
Hi All I have an index match formula that pulls info from another sheet from a status column made up of a drop-down with fifteen values. This is restricted to values. When I find the corresponding match, the formula works great, but if a value is not found, It returns a default value, which is not specified. I would expect…
Index Match from Column to Row
dashboard formula to show completions in last 30 days
Good afternoon, I am still a bit new to smartsheets. Would someone be able to assist me with creating a formula that shows how many requests have been submitted within the past 30 days? The goal is to use this on a dashboard so that any date you go on it will show the correct data for past 30 days of submissions. I am…
IF with multiple contingencies
=IF([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row > 5, "yes", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3 Weeks]@row = 5, "hold", IF(AND([Seen this week ]@row + [Seen Last week]@row + [Seen Last 2 Weeks]@row + [Seen Last 3…
IF (Contains... returning first matched reference
I have a formula to help apply a specific date to a column when a specific field is chosen (Block 1 = 1/27/23, Block 2 = 2/24/23...) this works just fine until I get to Block 10, 11 and 12; it is only returning the value of Block 1 Example Block 10 is giving me 1/27/23 when it should be 10/20/23 =IF(CONTAINS("Block 1",…
Auto-populate Time Zone based on address
I would like to be able to auto-populate a client's time zone in a column based on their address in another column. Is there a simple formula that can do that for me?
automatically update cell based on other record
Within the same sheet, there are two row types : Header and Detail. There is a Report Name Column that group these record together. Based on the image below. If record1 (Report01 and RowType = Header) has a Status = Approve, I would like all detail records under the same Report Name (Report01) to have Status = Approve…
Can a Form Total
Is there a way I can have a form total? I'm asking for a traveler's estimate for flight, hotel and registration. Can Smartsheet total these numbers before they submit the request for travel? Or do they have to manually add up the numbers? I have my backend sheet auto totaling, but the travelers don't have access to this…

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!

Trending in Formulas and Functions

Getting Unparseable error using IF function
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
SUMIF cell values land within a given week
Hey, I've gotten some fair formula experience over the last year (mostly through googling and this searching this forum) but hit a brick wall with my latest ambition… I have a smartsheet in Gantt mode tracking events and sizes relating to the event. I'd like to be able to use a date picker in the summary tab to pick a…
IF/OR Formula issue
Hi, I'm trying to pull data from another sheet if the date meets the criteria in one of two columns of 12/20/2025. Should I use an if/or or nested ifs? Here is what I have so far but get the #INCORRECT ARGUMENT SET error. Here's what I have so far. Any idea what I'm doing wrong? =IF(OR(INDEX({cutdate}, MATCH([Job ID]@row ,…

Formulas and Functions

Discussion List

Help Article Resources