-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
COUNTIF FORMULA ERROR
Hi all, I'm fairly new to Smarthsheet and have run into a simple COUNTIF formula error. I want to simply sum all cells in a column that contain the text "*C-000*". My formula is below and I don't show an error in the formula but I also have zero results where I should be showing a sum total of at least 26.…
-
IFS Formula with Past Due, Not Completed
Hi, Hoping I can get some assistance on a formula for to give me a count if the following is met: Count the # where: Type column is "Task" or "Sub-Task", Task Status column is "Not Started" or "In Progress" and End Date column is Today or In the Past I would like to not add any additional columns. Thanks!
-
=NETDAYS([Expected Finish Launch Date]48, [Planned Finish Launch Date]48) returns 1 when date is the
Using formula as follows should return with a 0 if the dates are the same. Why is it returning a 1 instead? A similar formula if used in Excel will return a 0, so I would assume Smartsheets would do the same. Am I missing something in the formula? Thanks, Lawrence
-
Hours Calculation
Is there any way to calculate the difference between two differente times, like: Column 01 ==> StartTime: 11:00 Column 02 ==> EndTime: 12:45 Column 03 ==> Hours: 1,75 Thank you
-
#REF in Predecessors
What do these errors mean in my Predecessor columns and the Edit Predecessor set-up window? I can't figure out what to do with them. I searched the Help Center and they say that #REF means "The formula references a cell which does not exist, possibly due to a row/column deletion." but this is not in a formula so I can't…
-
Accounts Receivable formulas for SmartSheet
Good morning, I am seeking formulas to help setup my accounts receivables SmartSheet based on the Status Stage from my project management sheet. Is there a formula for extracting from my "Invoiced" stage the cell history date from that cell. This is the date the status of that cell turned to "Invoiced". Then I will like a…
-
Using COUNTIF or SUMIF to evaluate a date range
Hi, so I have a ColumnA that has random dates for the current year 2017. The column is formatted as a "Date" style column. My goal is to sum each date in this ColumnA by Month: Example: So to the right of each date, I want the sum of all dates that are in "January" that are in Column A. Thanks
-
Nested Multiple IF
I have a formula I am trying to work out using multiple dropdown menu options that add different formula instances. I am trying to use multiple IF statements, but I am getting an unparsable error. Here is the formula, the dropdowns are 4 options LVL2 RBH, LVL2 OOH, LVL4 RBH, and LVL4 OOH. Note - IF I use only the first IF…
-
Help with SUMIF function with data from another sheet
I used this formula to set the range, the criteria and then the sum range but it is returning zero. The range is a different column than the sum range. Any advice? =SUMIF({SSS Range 3}, >"12/31/2017", {SSS Range 3})
