Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Two new PPM Functions: Successors and isCritical, available now!In Formulas and FunctionsHi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task…
-
Nest If/Or with ContainsIn Formulas and FunctionsSo with multiple drop downs I want the HC Froup to result in either one of three returns: backfill, backfill repuposed, or new. I am getting an uparseble error. Following is a snapshot of the attempt
-
Trimming all spacesIn Formulas and FunctionsHi, I am trying to apply a formula so that when meta data is input it is automatically trimmed to have zero spaces, which I know how to do in excel but does not seem to work in smartsheet. So, I have a column where we input license plates,…
-
Bulk UpdatesIn Formulas and FunctionsHi, I have multiple sheets that is getting data with formulas from one specific sheet that gets updated 3 times a week. I'm calling this sheet as the bulk update sheet. Since SmartSheet doesn't allow to import from excel on that particular…
-
I have one column Miles and a second column Billable miles.In Formulas and FunctionsMILES BILLABLE MILES (RESULTS) IF miles is > 1 miles -500, if miles < 500 "N/A"
-
Basic checkbox counting to apply status option to Parent rows onlyIn Formulas and FunctionsI am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exa…
-
Using Countif in place of Autonumber - formatting question!In Formulas and FunctionsI'm creating a ticketing system with multiple prefixes. Because of the multiple prefixes on one sheet, II opted to create a nested formula to number the tickets based on the various types of requests. Here is the formula: =VLOOKUP([Request…
-
Counting values within multi selection dropdown columnIn Formulas and FunctionsI used a multi selection dropdown column to select each company that sent in a bid for that project and I want to keep track of the total number of bids sent for each company. The formula I used is COUNTIF({Architect Selection}, "BSA&…
-
Index/Collect that should work, but is not returning values.In Formulas and FunctionsHello, Community! I've tried support and Pro Desk so far without success and could REALLY use your collective brain power. Here's the situation: I'm trying to use Index/Collect to bring the value of A into D where the Year for Role = 0 and…
-
Return ALL ID#s from another sheet if other Sheet equals "specific name"In Formulas and FunctionsHello Everyone, I am brand new to using smart sheets. I have a lot of experience us PBI but not as familiar with the smartsheet formula writing. I have a completely blank sheet and also a roster sheet with ID numbers and location names. Wh…
-
How can I get rid of rows that are not applicable?In Formulas and FunctionsI am creating a report with any upcoming tasks that are due within the next 14 days. However, when I do that, it pulls in my entire sheet, even rows that are in the future and not within the next 14 days. How can I get this to only show ta…
