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. …
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 …