Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
Announcing Several Formula Enhancements Available NowIn Formulas and FunctionsHi Community, One of my favorite things about Smartsheet is our powerful formula engine. We’ve been hard at work making several improvements that will not only make building formulas easier and faster, but can help you reclaim time throug…
-
What formula is needed to count specific catagories from a drop down (multi Select)In Formulas and FunctionsHi! I am hoping that someone has come across this and can offer a little insight on how I can do this. I have a sheet with a drop down column that has multi select. (Image) I want to count each time one of these selections is used and grap…
-
If this then that...In Formulas and FunctionsI am simply trying to create a formula that IF the job code is this, then it auto populates the corresponding Job Title into another cell. Is there a way to do this?
-
COUNTIFS + FIND QuestionIn Formulas and FunctionsHi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the…
-
Lookup formula instead of valueIn Formulas and FunctionsI am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?
-
Formulas and functions in formsIn Formulas and FunctionsHi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…
-
Formula WoesIn Formulas and FunctionsMy old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
-
Checkbox formula with percentageIn Formulas and FunctionsSmartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
-
Referencing a sheetIn Formulas and FunctionsHi! I'm wondering if there is any way to reference a full sheet. If you are able to do that and then write formulas that include columns within that referenced sheet, will that work? Thanks!
-
Formula to create a number assignment catalogIn Formulas and FunctionsHello, I am trying to create a number assignment catalog that is automated to speak to a smartsheet that has my full collection of products. The goal is when creating a new product anyone could fill out a form select the category numbers t…
-
Help with nested IF for distinguishing between 4 and 5 digit numbers in a cellIn Formulas and Functions(Image) Hello, We have a formula in this sheet that currently distinguishes between multiple PO#s in the PO column and separates them into individual columns when there's more than 1. In anticipation of using 5 digit POs alongside the stan…
