-
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.
-
Countifs + find formula
I have a formula I'm having an issue with. I'm trying to count how many projects are assigned to a individual in the "Assigned To" column that contains a partial description "green Ties" in the "task Name" column. here's my formula I came up with and need help to get it right. =COUNTIFS([Assigned To]1:[Assigned To]160,…
-
Using SUMIF to provide value of orders from this week only
Hi, I am trying to get a formula to sum the total value of orders invoiced this week. The formula i have tried is below, but returns '0' as the value. =SUMIF({Completion Date}, {Completion Date} = WEEKNUMBER(TODAY()), {Order Value}) The sheet references are to single columns titled 'Completion Date' and 'Order Value'…