Is there a way to prevent non-existent dates from being entered into a date formatted column?
I have found individuals have entered dates that do not exist (ex. 4/31/22).
I tested it out on a sheet just now. If I change the date column properties to have "Restrict to dates only" selected then it didn't like me entering 04/31/22. That should fix it I believe. Since you're the sheet owner (I'm guessing), then you'll get a warning which will allow you to enter a non-date but others won't get the warning. They just won't be allowed to enter non-dates or dates such as 04/31/22 or 02/30/22.
Thank you @Mike TV for the answer.
Being new to Smartsheet I had not noticed this setting.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
I am reaching out to seek your assistance regarding an issue I'm encountering while calculating the number of surveys completed on each day of the week (Monday-Sunday). Despite various attempts to identify the correct day of the week using functions like DAY, WEEKDAY, and DATEONLY, I am consistently facing discrepancies…
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
©2024. All Rights Reserved Smartsheet Inc.