hi guys, as you guys can see, the Check-in Column is a Created Date column, the left date is the date I pulled from created date =Check-in@row, but apparently it shows the previous date if my employee scan under 6-7 a.m
Hi @George Lie
System Date columns store date stamps as UTC, or GMT (although it can display the value in your local time).
This means that a formula looking at that cell will bring through the date value based on GMT, which is likely why you're seeing inconsistencies.
However, the Record Date Automation is based on local time! You could select a change in the Created column as your trigger, which only happens when the row is created. I would suggest using this workflow to populate a different date column, then reference this in your Start date column... or use it instead-of your Start date column? See: Set the Current Date with Record a Date Action
We are considering upgrading to Advance, and I have questions about Bridge capabilities: Our project blueprint includes multiple reports that pull entries from master logs based on the job number. This means that our admins have to add the job number to every single new report filter when they set up a project. Can Bridge…
Hi, Can dynamic views be accessed on smartphones/mobile devices? I don't see this option on the app.
Hi, I have set up a template in DocuSign and linked it to Smartsheet, however, I need to be able to set who is the signer internally as it will likely be a variable depending on the type of MNDA. Does anyone know if it is possible to enter a 1st Signer (Contact Person) then have the field for the final signer be variable…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.