-
Auto Created Date - Historic Data
Hi, Just started using Smartsheet and I've got to admit, I am impressed. I have a form, when the user submits data in the form, the timestamp is captured for when it is created. The problem is, I have existing data I want to copy in which gets deleted when I change the column to autonumber - Created Date. Best solution…
-
Primary Column Formula Issue
Im trying to create a formula where the primary column populates what is in one of 6 possible columns. I have a pretty simple formula right now (=Column Option 1 + Column Option 2 + Column Option 3 + Column Option 4 + Column Option 5 + Column Option 6). The problem is, Im getting a leading zero when the column thats filled…
-
formula to show month and year based off a date xx/xx/xx
Hi I haven't seen anything in the questions already so am hoping to get a quick answer here. I have a column named receipt date and am needing to see month and year based off of the receipt date in a separate column named mo/yr. Is it possible to create a formula for this?
-
Formula for determining parts in a 1.1.1.1 hierarchy.
I'm looking for a formula to determine how many parts are in a single assembly based on hierarchy. I'm using this equation which doesn't work: =IF(AND((LEN([Item Hierarchy]@row) - LEN(SUBSTITUTE([Item Hierarchy]@row, "0", ""))) / LEN("0") = 5, [Component Type]@row = "Assembly"), COUNTIFS([Item Hierarchy]:[Item Hierarchy],…
-
How to create a Nested IF formulae for the detailed below :
If Type is Option A, then Target Completion is Assigned Date + 7 if Type is option B, then Target Completion is Assigned Date + 15
-
What function would I use to reference a different cell in a row based on what is in another cell?
I recently asked a question similar to this and got an answer. However, I am having to go about it a different way, this is all on me, and now I am up against another wall. I am trying to reference a cell based on what is in the same row but a different cell. I am not doing any calculations so I cannot use @cell. Posted…
-
SUM with multiple conditions
Hello Smartsheet Community, Can someone please help me on this. I am trying to get the sum of the entire column from the cross reference sheet and the formula =SUM({Sheet Name Range1},[Primary Column]10) is working fine as of now but I want to add 3 more conditions to meet before getting the total value from the Sheet Name…
-
Pull back multiple values from a block of text
Hello! I am thinking this may be a lost cause but thought I'd ask. So I currently own several sheets where Quality Analysts listen to calls and leave a block of text. I've built a lot of tables, data trending, etc.. off those variables from a Column that is a Drop Down - Multiple Values column, but it requires that I read…
-
Using COUNTIFS and two CONTAINS
I've read most of the answers and using the recommendations, I'm still getting the error #UNPARSEABLE This FORMULA works, but I need to add another search for "DC" =COUNTIFS([DC - Status]:[DC - Status], "Incorrect DC") + COUNTIFS([DC - Note]:[DC - Note], (CONTAINS("duplicate", @cell))) so I've add another COUNTIFS and…
-
Calculating a future date based on a number of days
I am trying to calculate a future date using the date as it is 'now' + 90 days. I have read a few articles on here but I don't seem to be able to work it out I want to have the date completed - for example today / expiry term as 90 days and then it populates the expiry date (I can do this in Excel) Please help :) Thanks…