Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Operators documentation
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:
Comments
-
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
-
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
-
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:
-
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 &.
-
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 "&".
-
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.
-
Hi Matt, that is a good suggestion and I will pass it along to our content writer!
-
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.
-
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.
-
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.
