-
Forms
I need data to land in particular areas when entering into a Form... In my sheet I have Hierarchy's...Months, Jan through December. Under those sections I need the orders that are entered into a form to automatically be put under each area according to the date...thoughts??
-
Formula to auto fill date based on last non blank
I figured out the formula to give me exactly what I need in Excel: =IF(LOOKUP(2,1/(A1:D1<>""),A1:D1),EOMONTH(LOOKUP(2,1/(A1:D1<>""),A1:D1),3)) This formula does not translate to smartsheet. I need a formula that finds the last non blank in the row and auto fills a due date of 3 months later, last day of the month.
-
Conditional sum formula
Please be gentle, very novice smartsheet user! I am trying to get a total value on a smart sheet when certain conditions are met. I have a column called Type and a column called value, so when cell entries in column type are a particular value, I want a sum of the values recorded against that type in column value. And I…
-
AND + NOT isblank
Trying to produce a formula which says if X is blank and Y is not blank, then check. =IF(AND([Eval Cost]1 = "", (NOT([Client]1=""), 1,0) Thanks
-
Help with If ISBLANK or statement
I'd like a column to populate "late" based on whether another column has a date in it or is blank. Does anyone have any experience with nesting this type of formula?
-
Adding Nested IF Statement to Formula
I have a formula that calculates the "Planned % Complete" based on start and end date, with no weighting. We use it as a general guide because there is no planned % complete provided by Smartsheet. Formula: =IF(Start14 >= TODAY(), 0, IF(Finish14<= TODAY(), 1, (NETWORKDAY(Start14, MIN(TODAY(), Finish14)) /…
-
Formula for calculating years accurately
We need a formula for calculating years accurately when we compare a date with the date today – some examples would be: * Age in years: Today() - date of birth, currently we use: =(TODAY() – DOB1) / 365.25 but it doesn’t always give the correct answer. The 365.25 is days in a year allowing for leap years, or * Length of…
-
Newbie: trying to return cell contents if date is less than and greater than...
I'm new at this. Let's say these are my three columns: Open Balance | AR Due Date | WK 1 So in the WK1 cell I want this formula: If the AR Due Date is greater than 01/01/2018 and less than 01/07/2018, then return the value of Open Balance. I've tried, but keep getting errors. Thanks for your help.
-
Formula for SUM by the category
Unfortunately couldn't find the solution here. I'm just looking for a formula that will allow me to count total sum by the category of a product. Basically, I have two columns: first is the Dropdown list with the category of a product, and second one is the Text/number column with the bid amount. What I need is a total sum…
-
linking two columns togther
Hello Everyone, I have two columns, one has the name of the customer "name" and the other column has the number we assigned to the customer "number". I am trying to link these two for example, let us say if I type 111 in the number column the name joe will appear in the name column, and the other way around. If I write joe…