Formulas
Discussion List
- Is there a way to make the parent rows change based on the child rows? For instance, I want the parent row to show as complete, once all of the rows below are complete.
- Hello, The formula i am trying to put together is below: =INDEX(COLLECT({HBC Master File Product}, {HBC Master File Formula}, HAS(@cell, [HBC #]@row), {HBC Master File Plant}, CONTAINS(@row, "CBG COLD…
- I have a list of hundreds (thousands) of rows of data, most of which have one duration per unique identifier, but on occasion, there are multiple durations (usually never more than 6) for the same ide…
- Hello, I'm trying to make a formula so that when my "Task 100% Complete?" column checkbox is checked then it will automatically change "Fab Status % Complete (Needs Real Numbers)" column on that row i…
- I am working on a metrics sheet where I'd like to count the number of items that a given department has implemented within in a specific year. In this formula {Date Implemented} is a cross sheet refer…
- Looking to show 'Delay' for tasks that have %complete <100% and Finish date < than Today (). Tried multiple variations but some records come right and some just ignore the %complete record. Why? Formu…
- Hello Smartsheet Community, I am hoping you can help me with this simple formula. =SUMIFS([Start Date]:[Start Date], <=DATE(2024, 3, 1), Timeline:Timeline, "Tender Submitted", [Quote Total]:[Quote Tot…
- I am attempting to calculate interest based on a past due value in one of 4 columns. I need this formula to calculate all 4 columns because the amount may appear in one column this week and move to an…
- I am trying to return "Week Number of Year" (I want two digits for the Week Number hence the workaround in the formula) and all my weeks start on a Monday. I have used the following formula which work…
- Hello. I need to subtract one month from a date. I have tried =Date-30, and then minus 60, etc. By month minus 5, I was quite a bit off from the first of the month. If the Date being evaluated is say …
