-
IF Statement and Health
I 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 doing wrong in this formula? =IF([Move Complete]@row = "Yes", "Blue", IF([Move Complete]@row = "Termed",…
-
Month not displaying correctly
I 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:39 AM and the month column returns a 3. The formula I am using works for every…
-
How to count within a date range in first column and with a specific criteria in a second column
I 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],AND@cell>=DATE(2018,1,1),@cell<=DATE(2018,3,31))) Thanks ahead of time for any thoughts!
-
Auto Status Change/Update
Hi, 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 and the status box of completion is not checked yet, is there a way to create…
-
IFERROR and ISERROR do not work properly!
No 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") result is not - but #BLOCKED =IFERROR([Project name]1293, " - ") result is not - but #BLOCKED
-
Multiple IFS
Hi, 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 "" if no, or that same value ("IFC") if yes. I want to continue and test the same range for…
-
=upca Barcode Font Encoder
Hey! 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 was not imported, so the barcode creation functionality is now missing. Does Smartsheet…
-
Add additional filter or how to do this
Hello, 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 where the fields containing numbers from 1-5. So, I want to somehow make additional filter…
-
Need Flag or No Flag based on one or both of two columns being blank or within 7 days
Used 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 7 days and No Flag if the Date2 column OR Date3 column are blank. I think I got the blank…
-
Ignore #Dividebyzero
Hi, 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 in Excel using an AverageIF formula. But I can't see how to do it in Smartsheet.
