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
