Formulas and Functions
Archives for October 2020
Discussion List

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?

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?

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)

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…Answered  Pending Review 12 views 4 comments 0 points Most recent by Matt Scroggins Formulas and Functions

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…

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…Answered  Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions

Pulling data from a sheetIn Formulas and FunctionsGood Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that rec…

sequential number for each parent row  column formulaIn Formulas and FunctionsHello im trying to generate a sequential number for each parent row. I can do this using an helper column called parent that flags each parent record with 1 then the formula @row, 1) this won't convert to a column formula because of the ex…Answered  Pending Review 10 views 3 comments 0 points Most recent by David Tutwiler Formulas and Functions

Please help with lookup / index formula where there are multiple instances of the search valueIn Formulas and FunctionsHi All, I am new Smartsheeter and having difficulty in finding the correct lookup / index formula where there are multiple instances of the search value. I have tried a formula which works in excel (Index / Small / Row), but "ROW"…Answered  Pending Review 10 views 1 comment 0 points Most recent by David Joyeuse Formulas and Functions

Children reporting to parent  Checkbox and checking statusIn Formulas and FunctionsHi guys! I'm having a hard time figuring this out. I've tried to copy and edit all the formulas in this forum, so now I'm just asking the pro's. (Image) Two questions: I need to have the cell marked 1. on the picture check the children cel…Answered  Pending Review 9 views 1 comment 0 points Most recent by David Joyeuse Formulas and Functions