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
-
Need help summing data from a specific MonthIn Formulas and FunctionsHi everyone, I need assistance summing and counting data from a specific month. For the "Actual" column, I need two formula's in which it sums all the values up until the date I have under the "Date column", I also nee…
-
VLOOKUP with Multi-Select ColumnIn Formulas and FunctionsThis discussion was created from comments split from: Announcing Formula Support for Contact Columns.
-
Generate row IDs with new rows on topIn Formulas and FunctionsHey! I have a sheet in which rows are added from a Smartsheet form. In the form, I used the feature that new rows are added on the top of the sheet instead of the bottom. So every time there is a new entry the first row is the last entry. …
-
COUNTIF EXCEPTIn Formulas and FunctionsHello, could you help me find a formula that counts all except "x". I have a Column that has data such as: dates, "ok" and "N/A". I try using the Countif formula but cant seem to figure how to have it count a…
-
Smartsheet formulaIn Formulas and FunctionsHi Can you please suggest me with a formula that carries out the following function for me: IF %column = 100%, "Complete" IF%column = >25% and <=99%, "In Progress" IF %column = <25% "At Risk" IF %c…
-
Customizable Map ChartIn Formulas and FunctionsHello - I am looking to be able to show impact across the US visually on a map. For instance color code tier 1 states red, tier 2 states yellow, tier 3 states green. I have attached a picture of what I am thinking I would like to develop…
-
How to return blank rather than 0 with COUNTIF formulaIn Formulas and FunctionsHi - I have a 'COUNTIF' formula in a Roll-up Summary that is referencing a column with dates in another sheet to provide a count of dates within a specific range. If no dates are found within the date range specified, it is returning a '…
-
OR function Not Working with Multiple Logical ExpressionsIn Formulas and FunctionsHello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. Howe…
-
how to realize a projectplan with planned start/end/effort/duration vs. actual start/end/effort/....In Formulas and FunctionsHi all, we are successfull planning projects with smartsheet. Now we would like to compare planned start/end/effort/duration vs. actual start/end/effort/duration. Any idea how to do that? Baseplans? How to visualice two gantt bars planned …
-
Date FormulaIn Formulas and FunctionsI am creating a sheet to be used as a template for tracking tasks per contracts. For invoices, I would like to have a section that will have Invoice 1, 2, -12 but I would like to just be able to input one date and then have the other date…