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
-
When creating a work flow how to I get the alert to trigger based on a if a value "greater than" a cIn Formulas and FunctionsWhen creating a work flow, how to I get the alert to trigger based on a if a value "greater than" a certain amount of time?
-
Formula to auto calculate time difference in hours between two 24hr format times?In Formulas and FunctionsI'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…
-
CountIF with dynamic criterionIn Formulas and FunctionsHi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column I can get it to work by looking at a single row =IF(Engineer4 = [Approved By…
-
SUM totals of VLOOKUPIn Formulas and FunctionsLooking for help on a formula. I need the Forecast Adjustment column on (A) to add all amounts pulling (B). These should total $13,416.67, however, it it showing as $5,416.67. Please help! How do I change the formula to sum the VLOOKUPS? …
-
Help with an IF/AND/OR formulaIn Formulas and FunctionsHello, I am trying to write a formula to return today's date when all of the following are met: Column 1 is not blank Column 2 is not blank Column 3 is either Kangaroo or Platypus If any of these is untrue, then I would like the cell to…
-
Nest if/or formulaIn Formulas and FunctionsHi Community, I need your help... I'm trying to create a formula that captures "No Action Taken". The individual IF Statements are as follows: If [Flu Vaccination Date] is "Blank" OR If [Flu Vaccination Date] is "…
-
SUMIFS formula questionIn Formulas and FunctionsI’m working on a SUMIFS formula to add/sum numbers in 2 or more separate cells based on a checkbox input in 2 or more other cells. I’m able to do so only if the number columns and the checkbox columns are next to another. Is there a way …
-
Launch manual refresment of all linked sheet and cellsIn Formulas and FunctionsHi, I would like to know if there is a way to launch the smartsheet refreshment. I explain: I made many sheets with many cells linked together with formulas like Vlook up. When I change the searching criteria (for example a name include in…
-
Countifs project status is neither complete nor cancelledIn Formulas and FunctionsI'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…
-
Using COUNTIF to determine dept. but excluding projects that are HOLD StatusIn Formulas and FunctionsI can't figure out how to do this formula and I've been searching for it in community. I've tried the following: =COUNTIFS(Portfolio Rollups Range 1, "Corp IT",AND({Portfolio Rollups Range 8},="In Progress",{Portfolio …