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. …
Question: I wanted to see if there is a possibility to reference the begin date to end date from another cell instead of inside the formula. MY attempts to use a reference to another location has fail…
I know we can achieve this with helper columns in sheets, but I think it would still be a game changer if we could design Pivot tables that allowed grouping/summarising of dates by Month/Year without …
Hi All! I am looking for a way to add the date to a column when a check is placed in another column. I would want the date the check mark was added to the column. Any advice for the formula? Thanks ki…