-
Sort by month and year
I'm trying to summarize a sheet that has data from Sept '23 - Sept '24. I'm using this formula =COUNTIFS([Study Type]:[Study Type], "SOW", [Date Received]:[Date Received], IFERROR(MONTH(@cell ), 0) = 9) to sort by project type and month, but it's combining everything from September '23 and September '24. What can I do to…
-
Weekending Thought: Filter or Formula?
Anyone else ever have this thought when designing/building a solution? I tend to draft out different scenarios on a piece of paper and test them in Smartsheet to document the outcomes. What is a good practice you apply when designing/building your Smartsheet solution for yourself or clients?
-
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
-
Help on how to insert a formula based on another cell criteria
I want to create a simple subtraction formula that will only be added to the cell if another cell is one of two text responses. I know I could do the subtraction as a column formula very easily but most cells in the column don't meet the need for this formula so come back as Unparseable which just looks awful. This is what…
-
Systems and Services subscription renewal dates
I have a sheet which tracks the various systems we use and their monthly & annual subscription charges. We'd like to have SS tell us when a renewal date is approaching, particularly with the annual charges at first, but then have that date push out to one year (or month if it's monthly). A notification email would then get…
-
Populate Child due dates based on parent due date and (+/- number of days) column
I'd like to populate the due dates for child tasks based on the 'master' due date of the parent line, with the help of a "days out" or "weeks out" column. For example, I'd input the due date of the parent line below as December 31st, I'd want the child lines to populate accordingly with December 31st less the number of…
-
Index collect formula question
Hello I need some assistance with my index collect function, In one cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event], [Column23]:[Column23], [Week #]@row, Email:Email, "Person 1"), 1), "") In another cell i'd have =IFERROR(INDEX(COLLECT([Location and Event]:[Location and Event],…
-
Help with formula
I am currently using this formula and it works just fine. =IF(AND([90 Day Window 3]@row = "Ready", [60 Day Window 2]@row = "Ready", [30 Day Window 1]@row = "Ready"), "Ready", "Not Ready") But I am trying to add another part to it that has 2 things to referance to make true but does not work and Im sure its becuase or the…
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Determining the # of days formula
Im trying to calculate the number of days for a project based on the budget dollars $14,256.90 with an average of $30.00 per hour per employee for 4 employees (resources) and 8 hours per day
