-
Rename correct time zone for UK
Currently the time zone options available in Personal settings > Settings include 'GMT Greenwich' and 'GMT+1 Europe/Lisbon'. I am in the UK and selected the obvious one - 'GMT Greenwich'. Indeed it is the only zone mentioning a place in the UK. It turns out that this zone does not adjust for daylight saving time so gives…
-
Smartsheetgov users
Greetings! I would love to connect with other SmartsheetGov users to exchange ideas, best practices, and effective workarounds. I’ve found the platform to be somewhat limiting compared to the standard Smartsheet due to its secured environment. I am definitely looking forward to future enhancements, which is long overdue.…
-
WorkApps needs to enable multiple managers, owners, admins
I've seen several older posts requesting the ability to have more than one owner/manager/admin for WorkApps, but it appears that users are still limited to one admin per WorkApp. When will we be able to share ownership?
-
Anyone else having issues with search in board view not returning results?
I've just got a new team using Smartsheet in board view for easier collaboration. One issue though, is the search function is only returning matches when they're in the primary column - not in any other field. This isn't ideal and must be a bug. I've logged it as such but keen to know if anyone else is having the same…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
Count projects completed in a date range
Hello, I am looking to create a summary formula that calculates the projects completed within a given month. From the screenshot, I need a formula that evaluated the 'Status = Posted Live' AND the Actual Completion Date within March 2026. I've been playing with the CountIf formula, but I can't get it to work! Any ideas?
-
Pre-Populate a Form with Query String
Hi, I tried looking at previous posts here to make this work, but I am definitely not doing it right. lol. I am trying to pre-populate 4 fields in a form. Here is the test sheet (public) https://app.smartsheet.com/b/publish?EQBCT=d8c8d8b25bf0477e963e7c07a8ca81bb Below are the form fields I am trying to populate. Any help…
-
Setting up a metric sheet to calculate the YTD sum, but not show data in future months
I’m trying to set up a metrics sheet that will feed into a dashboard to show a rolling total over time, but I don’t want future months to display any data. For example, a user will enter values in the right-hand column, and I have a formula that calculates a rolling total in the green column. The green column is what I…
-
Copy text in Conversations
Why can't i copy a text message that was posted in the Conversations tab? Did this change with the last update as i was always able to do it?
-
Count IF(s) Formula Help
I need help with a formula in Smartsheet. I'm trying to count occurrences of specific values in my Issue Type column, but I have Allow Multiple Values Per Cell enabled, which is causing issues with the COUNTIF/COUNTIFS formula. For example, my expected results would be: Incorrect Product (6) Missing Parts (2) Defective…