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
VLOOKUP with multiple results
Hello! I have two sheets and I'm trying to find a way to bring to a order tracking sheet (2nd image) different information about shipping cost (1st image) but my vlookup brings juts the first result. can anyone help me understanding if there is another function? Shipment data sheet: Order tracking sheet: Thank you in…
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
Sum Collect if two different values met
I have added this formula: =SUM(COLLECT({Sheet - Sales Pipeline Range 10}, ({Sheet - Sales Pipeline Range 5}, "Closed Lost"), ({Sheet - sales pipeline loss reason}, "Price"))) I am trying to sum all values from Pipeline Range 10 column that have met the criteria of "Closed Lost" with the loss reason of "Price". What have I…
Sum of checked boxes
How do I add all of the boxes checked in a column? I have look but nothing is working for me. My column name is ALL YEAR
Workflow will not trigger if cell has formula
Hi all, I have a sheet with e.g. a cell with a function that calculates someting. The workflow should copy the line if the computed value = 1, but the workflow will not trigger. If I delete the formula and enter manually "1" then the workflow triggers. Is there any other way to have the workflow trigger in this case?
Duplicate check in two columns using IF OR and COUNTIF
I need to check two cells to see if they already exist on the sheet so I'm using a duplicate check formula and OR, but it's not working properly. It works for the email address, but the Full Name does not work. =IF(OR(COUNTIF([Full Name]:[Full Name], [Full Name]@row) > 1, 1),COUNTIF([Email Address]:[Email Address], [Email…
3 COUNTIFS
Hi, Is it possible to do 3 COUNTIFS ? Count if column 1 contains value 1, Count if Column 2 contains value 2 Count if Column 3 Contains value 3 any solution? Thank you!
Need help creating a formula that automatically changes the "status" based on several fields
Hi! I need help with a formula to automatically update the "status" column based on changes to multiple fields. The status column has three options: Not started, In progress, and Complete. -- If columns "Reviewer Assigned" and "Approver Assigned" are not blank, I want the status to automatically change to "In progress." --…
Unparseable???
I am trying to figure out why my formula keeps saying #UNPARSEABLE I am trying to take the first four digits of a project number and join it with 2 digits that are the suffix to create a new project number. Please help! Here is the formula: =JOIN(MID([Project Number]1,1,4):[Project Number Suffix]@row)
Help Article Resources
Trending in Formulas and Functions