Dates are being converted from UK format in the report to US format in dynamic view, cannot see anywhere in settings to change, can you help?
Hi @Dan Harris
Yep, was a nightmare for me as well :-)
If you use a helper column for the date so for example start has the date, the helper column is called Start Date - use the formula =DateOnly(Start) and then use that in the dynamic view.
Choose this in the main view with the columns.
If you want make it editable (so you can change the date) show that in the data tab, and it will give you the UK version to change to but the view in the main sheet will be from the helper column.
All the best
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have several grid sheets that have SUMIF summary formulas running. I’m working on a new sheet that requires I split the date & time that are included in one column. Summary formulas I would ordinarily run on the Program Start Date no longer work. Am I correct in assuming the summary formula will not operate on a column…
On my Smartsheet, I want to count the number of lots manufactured per year based on the date of manufacture. If the date is between 1/1/2023 and 12/31/2023, give me a value of "2023", and the same moving forward in 2024 and so on. I cannot figure out what the formula will be. Can someone please advise? Thank you in advance.
I'm looking to put together a formula that outputs a status based on a few criteria. This formula should output "Denied" by default. If the [Price] is $500 or less and [ManagerApproval] = "Approved", output "Confirmed". If the [Price] is more than $500 but less than $1000 and [ManagerApproval] = "Approved and…
©2024. All Rights Reserved Smartsheet Inc.