or Explore Discussions

# Formulas and Functions

Archives for June 2018

## Discussion List

• Formula help on IF ELSE
In Formulas and Functions
I want to have a condition where IF Delivered column checkbox is checked, then that whole row will be deleted. Is that feasible?   Can you please guide me how to start with it?
118 6
118 views 6 comments Most recent by Mike Wilday Formulas and Functions
• Beginner Formula Help - Extract Text from different cell
In Formulas and Functions
Hi, Please excuse my beginner's questions. We are starting to use scanning QR codes into smart sheet. Currently our QR code translates to the below text, where important values are delimited by "|" symbol. When the below text is…
196 3
196 views 3 comments Most recent by ricki Formulas and Functions
• IF function combined with Vlookup in 2 different smartsheets
In Formulas and Functions
Hello! I have another beginner question. Is it possible to combine an If conditional with a Vlookup? This is my scenario: I have 2 sheets:  Summary and Form. Columns in each sheet are: Summary Sheet: -Column Name -Column Question #…
481 4
481 views 4 comments Most recent by Silvia C Rodriguez Formulas and Functions
• RYG Ball Automation
In Formulas and Functions
Hello Community, How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do …
1 3
1 view 3 comments Most recent by Paul Newcome Formulas and Functions
• Help with formula (IF > AND > THEN)
In Formulas and Functions
Hi team, Could you kindly help me out with the formula syntax for the following scenario please: If the "Rag Status" column is 'Red', and the "Complete" checkbox is not checked, then the "Action Status" must…
12 4
12 views 4 comments Most recent by Paul Newcome Formulas and Functions
• Extract selected data from sheet (without using report)
In Formulas and Functions
Hi Smartsheet community! I have the following problem: I have a Smartsheet with a long list of items. These items will be shipped in several shipments and several collis, on different dates and to different locations. I would like to ext…
89 1
89 views 1 comment Most recent by Shaine Greenwood Formulas and Functions
• Creating an automated report
In Formulas and Functions
Hi, It's me again. Today I would like to ask if it is possible for reports to automatically select items that meet all the requirements of a set criteria. What I would like to do is make it so that when a task is completed and the box is …
103 1
103 views 1 comment Most recent by Paul Newcome Formulas and Functions
• vlookup - changes on source file
In Formulas and Functions
Hi, I've noticed that when you insert a column in one of the source files all vlookups in other sheets will reference an incorrect cell. Either it should be smart enough to know the change on the source and change it's formula or at leas…
12 1
12 views 1 comment Most recent by J. Craig Williams Formulas and Functions
• IF Statement Limitations?
In Formulas and Functions
I would like to write and IF formula in one column that involves 3 other columns. I'll do my best to explain what I am trying to do and the issue I am running in to. The first column is called "Building" and this is where I am w…
43 3
43 views 3 comments Most recent by Paul Newcome Formulas and Functions
• Building a formula to connect multiple cells between sheets
In Formulas and Functions
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually.  Situation is that that we have two files: pipeline and quote. Once the quote is complete…
156 3
156 views 3 comments Most recent by J. Craig Williams Formulas and Functions