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?
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 …
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 t…
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 ca…
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 …
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 birthd…
I am attempting to change the Fabric status column based off the dates in Fabric A,B,and C received date columns. I want to return a value of Received in the helper column if there is a date in Fabric…
We have different project types, and each project type has a different number of days is needed to complete a task. We have a sheet of about 30 rows that defines based on what project type, how many d…
Scenario: A sheet used to track customer request fulfillment has both a manually entered "Date" field and an automated "Created date" field. The idea being if needed, you could enter records after the…
Is this a Smartsheets bug? My formula is simply concatenating the date with the time. This seems to happen randomly when smartsheets updates itself, and it fixes itself only when I re-save the sheet. …