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
-
IF Statement and HealthIn Formulas and FunctionsI am trying to use the following IF statements for my health column. I get up to IF([Move Complete]@row = "Termed? ", "Red", and if I add any IF statements after that it doesn't work. Can anyone tell me what I am do…
-
Month not displaying correctlyIn Formulas and FunctionsI have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11…
-
How to count within a date range in first column and with a specific criteria in a second columnIn Formulas and FunctionsI want to figure out how many times a specific person sends an application out within a specific date range. Here is the formula I tried: =COUNTIFS(Name:Name,"Jane",[Application sent]:[Application sent],[email protected]>=DATE(2018…
-
Auto Status Change/UpdateIn Formulas and FunctionsHi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 …
-
IFERROR and ISERROR do not work properly!In Formulas and FunctionsNo matter if I use IFERROR or ISERROR formula Smartsheet always returns #BLOCKED Some how the back end ignores the IF/ISERROR formals and is returning #BLOCKED =IF(ISERROR([Project name]1293), " - ", "Green") re…
-
Multiple IFSIn Formulas and FunctionsHi, this should be relatively easy I think, but I'm struggling. I have the following formula (pasted below these comments) functioning to test whether a certain value exists (IFC) within a range on another sheet, and then returning "&…
-
=upca Barcode Font EncoderIn Formulas and FunctionsHey! I need to create UPCa text strings in Smartsheet. Currently we are using an excel spreadsheet that converts number strings into UPCa font values using an excel VBA macro. When I imported my Excel file into smartsheet, this macro …
-
Add additional filter or how to do thisIn Formulas and FunctionsHello, I need help to do something if possible. From my table, i want to make a filter which will show just the rows which has the specific terms. Ok, this is easy and I know how to do this. My issue comes when I have one more column w…
-
Need Flag or No Flag based on one or both of two columns being blank or within 7 daysIn Formulas and FunctionsUsed this formula to get No Flag and Flag result based on the date/whether the cell was blank. =IF(ISBLANK([Date1]2), 0, IF([Date1]2<= TODAY(7), 1, 0)) Now I need to get a Flag if the date in Date2 column OR Date3 column is within …
-
Ignore #DividebyzeroIn Formulas and FunctionsHi, I have a range of percentages and want to calculate the average. There are some #DIVIDEBYZERO cells within the range that will populate later on in the year. Is there a way to tell Smartsheet to ignore the #DIVEBYZERO? It is possible…
