-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Automated Date Capture Process with Recurrence
I have a sheet where we track Products (per row) and we need to track a user access review every year. To do so, I want to document the Product Owner and the Product Initiation Date - from there (when new row and product initiation date is not blank), I would need to auto fill a cell (Column: Next User Access Review) with…
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Date reference and subtraction MM/YYYY
I am trying to reference a cell in the same sheet carrying today's date in MM/YYYY format using =MONTH(TODAY()) + "/" + YEAR(TODAY()). I need to keep an up to date month reference in the sheet for a span of a year. How do I rerence the "Today MM/YYYY" cell and subract a month from it while maintaining the same MM/YYYY…
-
If And Formula including dates and isblank
Hello, I am trying to create a formula that will flag the column Delivered Out, if the On Hand Inventory is equal to 0 and the Date Delivered is today or in the past. Both conditions must be met so if On Hand Inventory or Date Delivered Out is blank, it does not flag Delivered Out.
-
Automate Date Fields
I have reoccurring tasks that have start dates and end dates. What I would like to do is after the status changes to completed, then automatically change the date fields to the next occurrence. For example: I have a task that has a start date of 7/1/25 and an end date of 7/10/25, and that task reoccurs quarterly. Is there…
-
Having difficulty with live 'Week Commencing' calculations and lookups
I've posted a related question here before, and although I got a response, it didn't achieve what I was looking for - therefore, I've changed my approach. Essentially, what I’m trying to produce is a live view of all new starts, transfers and leavers to be viewed by various stakeholders once they are officially confirmed.…
-
How to make the actual date earlier than the target date
I have sheets built for a team of engineers and they have a list of milestones with target dates and actual dates. Occasionally they will complete milestones earlier than the target date. My sheet will not let me set the actual date earlier than the target date. It will allow the actual date to be the same as or later than…
-
Have Smartsheet Forms Changed?
Hey, I have noticed that our forms have changed this morning and now have the more rounded feel that comes with Table View. In addition one of my forms now shows the date in the US region format of MM/DD/YYYY rather than the UK region format of DD/MM/YYYY and I cannot see a way to change this back. Has anyone else seen…
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…