dates
Discussion List
- I reference two created date fields from another sheet. I use the following formula to reference the created date: =IFERROR(INDEX({2a. FEMALE CHANGE ROOM Range 1}, MATCH(JOIN@row, {2a. FEMALE CHANGE R…
- This is my formula: =IFERROR(YEAR(TODAY()) - YEAR([Date of Birth]@row - IF(TODAY() < DATE(YEAR(TODAY()), MONTH([Date of Birth]@row)), 1, 0)), "") It keeps rounding to the next age. For example, 04/09/…
- Hi everyone, I'm attempting to build an annual leave tracker for my team. The current build is the employee completes a form with Start and End dates > this updates on a Request Log for managers to Ap…
- When I use a concatenate formula to combine a Date and Time to create an individual code, the Date appears in the default format 01/01/25 but the date in the Column it is referencing is formatted 2025…
- Hello, I'm trying to set up a formula which will calculate the difference between two dates to achieve a days overdue number for our orders. Current formula is: =IF(Status@row = "Delivered", NETWORKDA…
- 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 trainin…
- 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 differ…
- 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…
- 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!
- 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?