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.
Discussion List
I use column formula in a Parent & Children sheet and want to return a blank space in my parent row.
=IF(NOT(ISBLANK([PC&PM_COSTS APPLICABLE]@row)), VLOOKUP([Pack Code]@row, {PRODUCER COSTS Range 1}, 6), 0) / [Unit Weight Kg]@row The parent row does not use all the columns and returns this value.
IF(CONTAINS) #UNPARSEABLE
Hello, I would like to return vendor details using VLOOKUP function looking up per vendor only if service contact is available. In addition, if there is no vendor found on the reference page, text "Add vendor to Vendor List" should appear. Tried this formula and received error message #UNPARSEABLE =IF(CONTAINS(“Yes”,…
How so I get a report to sort in order of date?
This may just be a vent, but I have a report that pulls from about 15 different sheets with archived data from 2024 and 2023. I want the most recent submissions to show first. When I sort the report by the Date/Time column by descending order, it doesn't work. It'll start with 1/1/24 first and work through today (3/22/24).…
Copy Row to another sheet depending on data entered
I have a form the different locations can fill out. Each location has their own sheet we track data on. I want to copy the row to the location sheet. I am not sure if this is possible because when creating a workflow, it only allows you to copy to one sheet. Example: form entered for location A - I want to copy that row to…
Contact Collect/Join to Contacts will not filter (Current user)
I have contacts in a Collect/ Join in an [Assignee All Row] Field At its core: JOIN(COLLECT([RowRange1]@row:[RowRange2]@row, NOT(ISBLANK(@cell))), ", ") As far as I can tell ", " Comma-space is the delimiter for multiple e-mails in a multi-select column. FAILS: Filters on the sheets won't recognize (CURRENT USER) in the…
Updated formula returns blank??
Good morning! I have a formula that I have been using successfully for quite a while. I made a small update to the formula and suddenly it won't return the requested info. I have been looking at it for an hour now and can't see what happened to change what is returned. If in my source column I put any other trigger from…
Only Want Report Data Exported to Excel
I've created a report in smartsheet, and now want to export into excel. However, ALL of the original data from the master data sheet in smartsheet comes over. Eek! How do I only export the data in the Report? Thx, Becky
Updating Status Based on RYGG symbols of Children Rows and RYGG Formula
New day, new formula conundrums! For these formulas, I'm looking to update the status of my PARENT rows (2 levels) based on the RYGG symbol as well as having the RYGG symbol is based the CHILDREN rows' Task Status column. I have both working but I feel like they could be cleaner and just wanted to get a second set of eyes…
Cannot export
My smartsheet does not have the option to be exported.
Automation using formula field for conditional logic does not run
Hello, I have a few complex workflows where the approvals can go up to 4 people. Each approval level is set up as a separate automation and it triggers when the previous approval field becomes "Approved". the level of each case can be from 0 to 4 and that is determined based on a financial impact. I have an IF statement in…
Help Article Resources
Trending in Formulas and Functions