-
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?
-
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…
-
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…
-
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
-
Can you filter a sheet to view entries between two times the days prior?
I am looking to filter a sheet to show only entries made between 6AM yesterday and 6AM the day before yesterday. I tried using a helper column with the below formula to input a value that I could then use in a sheet filter to show only those rows with a value of "1" but am getting an error in return. =IF(Created@row <…
-
Recall AI Prompt at a Later Date
Absolutely love the AI companion. However, after a formula is generated, I lose access to the prompt that was used to write the formula. If at a later date, I want to come back and alter my prompt, have to completely re-write it, risking error due to human memory lapse, especially if the prompt is long and the resulting…