Formulas
Discussion List
- I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another…
- Hello, New smartsheet user here. I have cells that contain dimensions of objects. A cylinder, for example, looks like this: Ø120*12. I need a way to extract just the text to the right of the *, in thi…
- Column L44 with groups. ultimately ends up inside an if, but just trying base formula to eliminate everything else. #UNPARSEABLE =CONTAINS("In", CHILDREN(L44)) =CONTAINS("In", CHILDREN(L44@row)) #INVA…
- I am trying to create a formula across columns with different values in a cell. I have the formula for one value, Preliminary Draft. This works fine. =COUNTIFS({Comments Log Range 1}, [Document Name]@…
- Hi, I was working on a formula last week, but I am still struggling with a second criteria on this. the way its set up, updating the field depending on dates being input into others. this works well a…
- Kia ora koutou, I'm wanting to combine the PARENT and LEFT functions to copy the first 6 characters of the Parent cell as a label for the Child cells. In my work, each parent cell starts with a code a…
- Hi all! I'm working on a formula that will give me the number of days a work item has been processing with our support team. I've identified the following variables: 1.) When {IT Ref #} is not blank, …
- I have multiple line items for a order in one sheet(Request Sheet) and in another sheet (Order sheet) where I have clubbed all the items in single row, based on the order ID from request sheet to orde…
- Hi all, Looking for some help with the following IF/AND Formula please which could result in the following answers: If Task Status not equal to "Completed" then return "Currently Incomplete" If Task S…
- Based on information I've found here, I've created a formula that identifies overlapping times that occur on the same day, but I'd like to adapt it to incorporate items that occur over multiple days. …
