Formulas
Discussion List
-
Symbols Color Change based on DatesIn Formulas and FunctionsHello, I'm looking for a formula that will automatically change based on close we are to the due date. So let's say the following: 30 days till the live date, Green 15 days till the live date, Blue 5 days till the live date, Yellow under…
-
Sales Projections SheetIn Formulas and FunctionsHello All: I'm working on a sales projections sheet and looking to create and easy to notice symbol, on target, below target, and off-target. What is the formula to be able to easily create this? Thanks in advance. MH
-
How to convert a number with a fraction reading as text, to a number (3 2/3) to 3.66In Formulas and FunctionsI'm having an issue with incoming data being read as a text. I need it changed to read as a number so I can incorporate formulas. I've tried a few value formulas. The initial formula to pull the numbers from the original text is substitute…
-
Need to create a column that translates "End Date" Month to QuarterIn Formulas and FunctionsTrying to create a column that tells me which quarter an item will be ready in the future. I can get the Month of the Date cell easy enough but can't figure out how to do a value range that works. This works =IF(MONTH([End Date]@row) <…
-
Why sometimes a formula works and other times it shows #CIRCULAR REFERENCE?In Formulas and FunctionsI am working with this formula IF(ISBLANK([MoH ID]@row) = true, "", IFERROR(VLOOKUP([Val ID MoH]@row, {2.1 MoH Range 1}, 16, 0), "Error ID Trámite")). It worked for a few weeks and then suddenly when I open the sheet th…
-
Last Week's ValueIn Formulas and FunctionsHi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically…Answered - Pending Review 14 views 2 comments 0 points Most recent by JeremiahHorstick Formulas and Functions
-
Max out Cross sheet reference ?In Using SmartsheetI have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the c…
-
Zero FormulaIn Formulas and FunctionsWhere do I find the formula to have a cell display nothing when the total becomes the number zero? I have a sheet with zeros in multiple places and it clutters to much.Answered - Pending Review 764 views 15 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Multiple IF statementsIn Formulas and FunctionsHi, I'm attemping to assign PRICE to items based on CONDITION and CATEGORY but my limited skills with formulas are keeping me from my desired results. I'm hoping some one can help me out. In my PRICE column if have the following formula. …
-
#INVALID VALUE Error - Can't figure out why...In Formulas and FunctionsI am working with two sheets. "Payment Tracker" and "Job Tracker". Payment Tracker: Auto: Auto-Number Column - No formatting Row: =MATCH([email protected], Auto:Auto, 0) Invoice Number: Primary Column - Manual Entry Invoice Amou…