-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…
-
[UPDATED] Community email notifications and saving important posts
Unsubscribe or Manage Community Email Notifications In the upper-right corner of the Community, click your Profile > Account & Privacy Settings Choose Notification Preferences from the options on the right. You can subscribe to any of your Followed Topics to receive notifications for every new post in the online Community!…
-
I have a "Current Project Log" with 2024 accounts. How do I move to "2024 Log" & keep dashboards?
Hello, Due to the size of our log I can only keep 1 year's worth of data in a sheet. I have monthly and YTD metrics/dashboards that pull from the current sheet. I need to move 2024 into a new sheet to make room for 2025 projects, but I know doing this will cause issues with the dashboards. Is there a way I can do this…
-
Ability to change the primary column at a later date
It would be convenient if you could change the primary column at any time. I have an existing sheet and would like to switch the primary column to a different text/number column. I know there are workarounds to get the end result, but it would be super slick if you could just change it by editing the column properties.
-
Archiving Rule in Control Center Not Working As Expected
I have several completed projects located in an intake sheet that I would like to archive. I created an archive rule for projects with a status of "Ready to Archive" to move to a separate workspace. I also checked other freeze & disable features for items. When I tested one project, the only thing that worked correctly was…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Allow ISO 8601 Date format for dates (YYYY-MM-DD hh:mm:ss)
ISO 8601 is an international data standard and a part of two national standards in the United States. "The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting numeric dates and times when such data is transferred…
-
Ability to Select Default Opening view
It would be fabulous to have the ability to select a tab or area to open automatically when I open Smartsheet, specifically my favorites tab. This way the projects I am focusing on or touch everyday appear automatically when I open the product. Could be an option in my profile settings? One less click and can keep views…
-
Why is my WEEKNUMBER returning two different weeks for the same day?
I have a function that counts if a form was filled out at least once a week. They are supposed to have from Sunday 12:01 am to Saturday 11:59pm to finish the form. I have 5 submissions for Sunday 01/05/2025 and two are reporting to the wrong week. How do I fix this?
-
Multi- Row Solution
I am trying to create a workflow for an expense report that allows me to turn it into a PDF. Is there a way to utilize the generation of multi-row so I do not have to create columns for each individual expense?