Operators documentation

Matt Seitz

Where can I find documentation for which operators Smartsheet supports in formulas?

Note: I am looking for documentation of operands ("+", "&", "<", etc.) not functions (SUM, INT, MAX, etc.).

For example, here is the page that documents which operands are supported by Excel:

https://support.office.com/en-us/article/Calculation-operators-and-precedence-48be406d-4975-4d31-b2b8-7af9e0e2878a

Find more posts tagged with

Formulas

Comments

Stefan Siebenkittel

Hi Matt,

do not fear the help center of Smartsheet; it's really helpful ;-)

http://help.smartsheet.com/customer/en/portal/articles/775363-using-formulas

J. Craig Williams

Matt,

In the link provided by Stefan, you'll also find a Template with all of the formulas and helpful examples.

You can use the template to create a sheet that will be waiting for you when you need it. I changed it back to a Template but that keeps it local to my environment and easier to get to. Also, the Search feature finds items in the local templates, so it is a quick way to get answers I am looking for.

Hope this helps,

Craig

Matt Seitz

Sorry, my question wasn't clear. I am looking for documentation that shows all the operators (+, -, *, / <, etc.), not the functions (SUM, INT, MAX, etc.).

For example, the following page shows all the operators that Excel supports. I'm looking for something similar for SmartSheet:

https://support.office.com/en-us/article/Calculation-operators-and-precedence-48be406d-4975-4d31-b2b8-7af9e0e2878a

JohnHinkle

Hi Matt, the Help Center article and template will show most of the operators available inline with functions. There isnt a separate section that shows only operators. I think you will find most of them will work in formulas, just like Excel.

Looking at the link you shared, they should all work in Smartsheet except "%" because percent is identified as a number. 1 = 100%, .42 = 42%, etc.

Also, "&" isnt used to connect or concatenate. In Smartsheet use + instead of &.

Matt Seitz

Thanks, John. It would be nice to have one page that clearly documents all the operators. Especially if some operators that are different from Excel, like "&".

JohnHinkle

The help center article DOES reference most (if not all) operators, they just are not all in once place. For example, + - * / and ^ are all in one section (Numeric Formula) and if you want to know how to concatenate, just search for it on the page and it will show you how to do it. Its a great article with information on most things you want to do. Try using your browser search tool to find what you are looking for.

Travis

Hi Matt, that is a good suggestion and I will pass it along to our content writer!

Matt Seitz

John: thanks, I know you're trying to give me alternative solutions. But before I came to this forum, I tried using search in the Help Center. But I still couldn't find the answer I needed.

I was looking for a "not equal" operator. I wasn't sure if it might be the same as Excel, "<>", or maybe the opeartor I'm used to from my C programming days, "!=".

So, I went to the help center and searched for "operators", because that's how I'm used to finding operators. No luck. So then I searched for "formulas", and went to the section on "Logic Formulas", since that is where comparison operators are often used. In that section, I found an examples with ">" and "=". But I couldn't find an operator for "not equal".

In the end, I decided to just try the Excel "<>" operator, and it worked. But next time, I would prefer to have the answer documented somewhere, instead of just relying on trial and error. So I was hoping that maybe there was such a refernce document somewhere, and I was just having trouble locating it.

Another thing I like about having all the operators documented in one place is that it makes it easier for me to discover new operators. That's how I discovered the "&" operator in Excel.

Matt Seitz

John, Stefan: Sorry, I finally looked at the template. You're right, it does look like that does contain many descriptions of the supported operators, including the "not equal" <> operator.

I still think it would be nice to have that documented in the Help Center web pages. It was not obvious to me that the template was the place where I would find this information.

robert.suddath

I came here for the exact same reason as Matt. I do not see the template that was referred to. Are y'all referring to the individual function pages?

I agree that it would be helpful to have a list of operators. For example, the IF page does not list any operators in the usage notes like are listed on the COUNTIF page. Having an operator table that could be linked to from each function page would be extremely helpful and would provide a single point to update if the operators we to change for some reason.