I know I'm missing something small and I cannot get this formula to work. Basically you throw a date into the "desired start date" and it will populate a small timeline of required milestone dates bas…
Hi all, I'm very new to SS and maybe am going about this backwards....GOAL: I'm trying to create a running countdown between the current day and the due date of a project. I figured out to use this fo…
I am trying to create a report that displays the parent and the children rows, but the criteria is only based off the parent. For example, each parent and children have statuses. But the parent row is…
I am trying to edit a formula for our naming convention column in SS. The below is our current formula. At the end it pulls in the year according to today's date. Instead we want to remove that and ha…
I need a formula that returns the minimum date from a range of dates that is greater than or equal to today's date. I use the MIN function to return the minimum date in the range but, I need the minim…
I am looking for a solution similar to the Ctrl+E flash-fill feature in Excel, or a formula to extract just what I need into another column for export. For example, I need a column that has informatio…
I am attempting to get this formula in my tracker sheet to work to count all the instances in the reference sheet where a certain month in the date column occurs and the answer to a question in anothe…
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and membe…
Hi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form j…
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVA…
