Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered …
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projec…
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but…
Would love the ability to choose a date format in dynamic view. We share our smartsheet with international partners, so the ability to set the date format to unambiguous dating (dd/mmm/yyyy) is crucia…
Hi, I'm trying to create a formula to work out the difference in days between 2 cells, both of which have values derived from different column formulas. The output column is giving me #Invalid Data Ty…
Is there a way to set a date requirement for a form submission on a Smartsheet? Meaning, I have a Smartsheet that is for event request. There is a form that auto populates this Smartsheet. I want to s…
I am in Victoria, Australia and I am using a form to populate a sheet. I want to automatically populate the Inspection Date to be the date the row was created. I am using the formula =created@row The …
I am stuck getting this to work and have been trying both ISERROR and ISBLANK but keep getting an UNPARSEABLE error. Here is the overview of what I need to do: First, I have a column [Cumulative Delay…
Hi, for our ticketing system, I am using a DATE formula to only pull the date (Date column) from when a request comes in (Request Date column). I use that "Date" as part of formula to calculate how lo…
Hi there, I've set up an automation on a sheet and noticed that the dates in the automated emails are in the incorrect format, despite me setting my regional preference in the settings. I have the dat…