I have a grid sheet full of contracts: each row is a contract. Each row has a START DATE and END DATE along with other details about the contract. I was tasked with creating a dashboard to represent t…
I'm trying to write a formula to calculate the next monday, wednesday, and friday following a particular date. The AI formula generated =IF(ISDATE([Start Date]@row), [Start Date]@row + (8 - WEEKDAY([S…
I need to calculate the 3rd Friday of each month consecutively on a sheet. I am looking for a formula that will take the date of the previous line and spit out the next month's 3rd Friday, in sequence…
I set up the automation below, and it's not working. When I change the status of a row to complete, nothing happens. If I go into the automation manager and select "run" or "test" the completion date …
Morning Smartsheet community, Hope you all had a great festive period. I'm struggling with a formula that would make my reports a whole lot easier….. I have a helper column that I want to return a val…
I will use the following as an example for my problem: I have a pre-existing sheet ("Team Employees") where different teams record their # of employees once a month. This was used to track live staffi…
Happy New Year All. I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS However, I have a simple IF statement and just cann…
Hi All, I am trying to add a Follow Up Date to my sheet, following a Submission Date. I tried: =[Submission Date]@row + 14 and instead of getting a date 14 days in the future, I am just getting the nu…
Hello! I'm trying to have a cell populate with the date that "APPROVED" is clicked. Ex: If "DC Ha Review" has "APPROVED" chosen in the dropdown, I wanted the Approval Date column to populate with that…
I am trying to utilize an index collect formula that will cross-reference another sheet. Some of the reference criteria are numbers but two criteria need to narrow the options to a specific date range…