-
Form Submission Date Requirements
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 set it where the submission date must be at least 2 weeks (14 days) prior to the requested event date on the form. Is this…
-
Different Dates on the one sheet
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 Created date, being the system generated date is correct, but as you can see the Inspection date using the above formula is…
-
Help with ISBLANK on column formula
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 for Start Date] that increments based on other values for a row. The second column is the base starting date [CALC DATE]…
-
DATE Formula results in Next Day when Request is Submitted after 8pm
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 long it took us to complete the ticket. But as you can see in my screenshot, if a request comes in after 8PM (I am on the East…
-
Date format in automated emails
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 dates set up in my settings for Brazilian format (i.e. DD/MM/YY) and this is how it shows in the Smartsheet itself. However, I…
-
Extract a MM/DD/YY Date from M/D/YYYY HH:MM
I'm looking for some formula help to convert a date format. The date column I'm referencing is coming in from another source, and is formatted as M/D/YYYY HH:MM - here's some example data from the sheet: I need to compare these dates to a user-set date (column = Prior Run Date) in my sheet, which is a Date column type…
-
Getting #Invalid Operation
I have the following formula and am getting an #Invalid Operation message. I only get the error though when it returns "Red". The column is defined as a Date and is restricted to dates only. I think it has to do with the TODAY() part of the function. =IF(AND([Due Date]@row < TODAY(), [Due Date]@row > " "), "Red", "Green")…
-
Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
-
Return different value based on date
Hi, I'm trying to write a formula to return different values based on the reference date ([Next Calibration/PM Date]@row) compared to today's date. I want the equation to: If the cell is blank, return as "Pending", If the date is < = today, return as "Overdue", If the date is > today, return as "Current", If the date is…
-
"Record A Date" automation not working
I'm trying to set up a multitude of automations where, when the status of an item is clicked as "complete" it will auto-populate the date into a date column. I set up an automation for this function but when I go back into the sheet to test the function, it's not working. I previously set up a conditional format that…
