-
Duplicate/repeat column settings
Hi! I tried looking for this question in various ways in the community group, as it seems fairly basic. However, I'm just not finding any keywords that are leading me to the same aspect I'm trying to figure out. Currently, I'm having to create multiple columns that are exactly the same setup - or close enough. I'd love to…
-
Quick filter on columns (like other spreadsheets do)
I'd like to be able to just do a quick filter on a column or more than one column without having to create a whole filter on it. For example, I'd like a quick dropdown on "Responsible" where I could check of one or a few names and it'll just show me those. Then I could do a quick filter on "Status" column and select only…
-
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Increase the Latest Comment Column Character Limit
The 'Latest Comment' column is a great feature to add the most current information into sheets and reports. It's helpful to be able to provide our executive team printed reports containing all of the information they need. And they don't have to worry about accessing Smartsheet directly. Unfortunately, we recently found…
-
Auto Number Column - what happens when numbers run out?
I have a sheet with an auto number column which I expect to get very large. What happens when all the available options for unique numbers are used? For example, once I have already used 001-999, does the next row start at 001 again, or will it stop populating numbers? Or will I get errors? I have chosen the option with…
-
Allow single cell references to be converting to column formulas
Currently when you want to reference a single cell in another row you cannot convert the cell formula to a column formula without getting a syntax error even though the formula works fine as a cell formula. I need this functionality as I am trying to figure out a work around to do round robin auto assignments for new items…
-
Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc. How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list. or do i need to create a different contact list/column? if so, how…
-
Merged: Grouping Columns
This discussion has been merged.
-
CONFLICT COLUMN (Shows where issues are when scheduling)
I have started to develop a CONFLICT column, that is, a column to show/ highlight where the same ASSIGNED TO/ RESOURCE/ MACHINE has been allocated on the same day, thus identifying potential conflicts in the schedule. The columns counts the number of instances where the START DATE and ASSIGNED TO are the same and only for…
