-
Identify Most Recent Record
Hello, I am using SmartSheet to log Training Records. Every time a record is submitted, I am recording three fields: Date, Name, Topic. Based on the date, I am projecting forward the next time training needs to occur. (ie: 3 years after most recent training record). This occurs in a "Renewal Date" Column as a column…
-
Convert day of month to Business Day date
We have a calendar template that we re-use every month. On this calendar ,we have a column that is the numerical representation of the day of the month (1, 2, 3, 4, etc.). Each month, this is a different date. Currently, someone is manually entering the dates that correspond to the day number. Is there a formula that would…
-
Track Form Submissions By Date
My organization has several forms set up that are utilized quite a bit. I'd like to track how many forms are submitted on a given day, week, month, quarter. I have tried countifs, and a whole bunch of other formulas. I also made a report but I am unable to pull report metrics into a dashboard so that it can visualized…
-
Add months to a date
Hi Team, I need to create a formula to add X months to a date (X) to calculate a due date. Any suggestions? Thanks in advance!
-
Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025
I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
-
Filter option for all Incoming Dates (or Outgoing Dates)
It'll be super helpful for our Schedule Owners to have Filter for all Incoming (or Outgoing) dates when they have many incoming dates in their schedule. (Sometimes those are start dates… but some are in deadlines etc. ) I know if we add helper column to capture that we can do that, but it adds additional steps and more…
-
Restrict number of times date is allowed to generate?
I am looking to formulate a column to generate a date based on the submission date and turnaround time of the type of task. However, we only want to allow each date to generate up to three times. If that date reaches a fourth date, then we want it to add a day to the generated date. Example: Doc1 received on 2/24,…
-
Date Range in Date Column + Automation
Hello! I have an automation that currently sends users alerts based on the date in a column called "End Date". A majority of the time, the end date is a single date. However, sometimes the end date can be two or more days (ie- May 7th-8th). While I can write into the date column ="May 7th-8th", that will prevent my…
-
Return a date or month
Hello! Is it possible to write a formula to get the following result - Start Date Column: if it's a confirmed date, a date two weeks earlier in a photography due date column is calculated (this works by using this formula: (=[START DATE]@row - 14)) HOWEVER, if a start date is TBD and I put in the Start Date Column "March…
-
Date Format Options within Dynamic View Details Panel
Would like the option of utilizing different formats for entering date values within the Dynamic View details window. Currently the only option is a standard MM/dd/yy. When non-tech users enter birthdates etc. they often enter the last 2 digits for the year and the date defaults to 2000's creating issues. As an example…