-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
-
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…
-
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…
-
New Column Type: Time
In Sept 2023(ish), Smartsheet introduced a TIME function. To further utilize this function, a new column type should be added, called "Time." This column type will function similarly to the "Date" column type in that it will only accept values formatted in a specific way and, most importantly, can be used to trigger…
-
Find and Replace Function in Formulas
Having the ability to find and replace items in formulas would be incredibly helpful and save time as we update certain sheets each year.
-
Reference Auto ID column and other fields in automated Comment emails
Context: When entering comments, the automated email that gets sent when @someone is used references the row number of the comment. Row numbers change as items are added and removed, which can lead to confusion when only referencing the row number. Using the Auto-Generate Row ID functionality provides a static identifier…
-
Merged: PRINTING GROUPED REPORTS AS THEY APPEAR
This discussion has been merged.
-
Function "Current User"
Of course, the information about the current user is already available in the system, after all we can access it via filter. But I miss a function that would allow identifying "Currentuser()" via formula. I'm making individual dashboards and would like to generate personalized statistics for each user, which are…
-
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?
-
Unhide specific columns on a sheet
Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.
