-
Record a date of last attached file
Hi all, I have a main sheet that gets updated every time we manually attach a new file to it. I have a number of reports and dashboards that automatically update upon this manual attachment. I would like to record the date upon which the main sheet was updated specifically via attachment of this file (we update the sheet…
-
Count based on Multiple Criteria & Dates
Hi, I am attempting to create a formula that would = Count the number of training items completed per team member and between two dates. I created this formula, it is giving me all Zeros: =COUNTIFS([Actual End Date]:[Actual End Date], <=DATE(2024, 1, 1), [Actual End Date]:[Actual End Date], >=DATE(2024, 12, 30),…
-
If formula with Date and Time
Hi. I created the formula below to close a dynamic view on Oct.30th. =IF(TODAY() <= DATE(2024, 10, 30), "Open View", "Lock View") How do I adjust that formula so that the view can be locked at 5pm on that day?
-
Automation-Date in the past
I have a column named "Shipping Date" and then, a second column with a formula that gives us a date 5 weeks prior to that "Shipping Date". This second column triggers and automation to contact the customer once the date is reached. What if the line is entered and the 5-week gap is a date in the past? How should our…
-
Help with COUNTIFS
Hi Community! I am hoping someone can help me figure out how to correct this formula or create a new one. I want to count how often the regional VP’s name appears in a row with a date within a specific date range (quarter). Current formula I am using in a calculation sheet and referencing another: =COUNTIFS({TLH User…
-
Counting Days with plus or minus options
I know, I know… use =Networkdays([start date]1, [end date]1) HOWever, I am trying to track the performance of when a job is completed according to its due date. I found adding a -1 to to stop the inclusiveness of the calculation, whereas I can get a job completed on 10/5 that was due 10/6 to show 1 day using…
-
Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
-
Calculating past date from a January Birthday
I thought I had this all figured out a while back, until diving back in now I notice that a handful of my dates are not working correctly. I figured out it is all of the rows where the person has a birthday in the first couple weeks of January. I want to take the birthday and create a date range that a survey can be…
-
Change default date format for the organization
The current default date format is MM/DD/YYYY for all sheets in Smartsheet. Many people in our organization dislike this format and opt to change the date format for individual sheets they are working on to be in a different format, such as DD/MM/YYYY or YYYY-MM-DD. The issue is that when different departments and teams…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
