-
Record a date automation isn't working
I set up the automation below, and it's not working. When I change the status of a row to complete, nothing happens. If I go into the automation manager and select "run" or "test" the completion date column fills in with today's date. What am I doing wrong? This should be straight-forward. I've tried building this…
-
Modify Date Format in Dynamic View
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 crucial.
-
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…
-
Can we set Request for Update to run only on Business days or based on Business days?
Can we set the request for update to be sent based on business days rather than calendar days? For example, I want the automation to send to staff assigned if no change in activities of the row for x days. We want to set this to be business days instead of calendar days. Would this be possible?
-
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…
-
Date format incorrect on forms
Since the updates to the forms, some of the forms we use now have the dates showing as mm/dd/yyyy rather than the format dd/mm/yyyy. Is anyone else having this issue, has anyone else found a way to resolve this? Thanks, John
-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
Merged: Feature Request: Duration Calculation from Date & Time Columns
This discussion has been merged.
-
How to use a nested if with count
We would like to have all the criteria for a created date by week. the number of new helpdesk tickets created by each end user for a given week. Example: Week of 7/7/25 Mickey submitted 5 tickets, Donald Duck submitted 10 tickets, part of Donalds 10 tickets only 5 were reported in week 7/7/25. Report Week of 7/7: Name:…
-
IF Statements with Dates
Hi all, I am clearly missing something… I have a sheet with columns for the Start and Date Ends and then another column to track the Status (In Progress, Enrolled/Upcoming, Completed). The formula is currently: =IF([Start Date]@row > TODAY(), "Enrolled", IF([Start Date]@row < TODAY(), "In Progress", IF([End Date]@row <…