Formulas
Discussion List
-
Disregarding N/A in FormulaIn Formulas and FunctionsHi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Sum…Answered - Pending Review 26 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Separate numerical and text values of differing lengths from a single cell into separate columnsIn Formulas and FunctionsHow do I separate numerical and text values of differing lengths from a single cell into separate columns? For example, I'm trying to total the "AREA" Column, but due to having "SF" in the cell, it will not return a num…
-
Solving for data issue when exporting data from external source.In Formulas and FunctionsI am trying to create a helper column that will help a colleague manage data that he needs to export from our inventory management system to evaluate in a team meeting. The issue is that he has currently been manually fixing a common data …
-
Is there a way to have a cumulative formula?In Formulas and FunctionsHey everyone, I would like to know if there's a formula that calculates the cumulative time because I have to drag it down everytime. I have 3 columns: 1) Task 2) Task Duration 3)Cumulative time I know that for row 2, I can just do [Task D…
-
Formula for parent, child, grandchild auto add rowsIn Formulas and FunctionsI am building a spreadsheet for our new hire onboarding and IT checklists. When I add a new name I would like it to auto populate children underneath it. See my screenshots below. Row 7 (Parent) - Dark blue would be the start date for new …
-
Is there a formula to indicate the change in status direction if updated in a given time?In Formulas and FunctionsI want to indicate with up/down arrows in a separate column, if the RYG status for a line item has changed direction in the last X days. e.g. if status went from Red to Yellow, Red to Green, Yellow to Green in the last 30 days - show an up…Answered - Pending Review 18 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
How to find the lowest value number in a gap from a sequence of numbers?In Formulas and FunctionsHello! I am currently working on a sheet that will allow us to assign a numbered item to a teammate and keep track of who has what numbered item for traceability purposes. The audit process has been completed and fully automated but I wish…Answered - Pending Review 21 views 3 comments 0 points Most recent by Mike TV Formulas and Functions
-
Why isn't there a function to return the row number?In Formulas and FunctionsWe have [column]@row. Why not =ROW()? I really need a column formula that returns the row number.
-
Multiple IF AND ISBLANK Criteria in FormulaIn Formulas and FunctionsWhat I'm trying to accomplish: If [Approved] is checked, change [Status] to "Complete" If [Ad RSS Link], [Subject Line], and [Done] are not blank, change [Status] to "Proofing" If [Ads Entered] is checked, change [Statu…
-
Apostrophe being inserted before Formula when using Smartsheet FormsIn Formulas and FunctionsHello, we have a Sheet setup with a Column which has the Formula =[Project]@row + " " + [Note]@row taking the info from the Project and Note columns. We also have a form for this sheet where you pick the Project and add a Note, w…