-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
Column Descriptions in Reports
Column descriptions from sheets should also be visible on all reports using that column. It is important information for anyone using a report, just as it is for those viewing a sheet. Thank you
-
Increase the limit within Contact List column
Currently there is a limit of 20 contacts within the Contact List column, which is not sufficient for our needs. It would be great to either increase the maximum to a significantly higher number, or removing the limit whatsoever.
-
Can I filter by columns, not rows?
Hi. I'd like to filter a Smartsheet like this… … show only rows where (<column4> is checked OR <column8> is checked) Is this possible? I can only see filtering by row values, not column values. It is not practical for me to transpose the Smartsheet because the primary column has long text and contains over 100 rows.
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.
-
Control Center - Ability to reorder columns, or reset all columns to predefined order
Please add the ability to 'reset' column order across sheets to match the template. Currently in control center, you can add (or move) a single column to a single destination point. As I understand it, that destination is based on the column position number. So although you may be showing it going in between "Assigned to"…
-
Need a formula to fill in a column based on a date column
Hi! I have a date column and i would like a forumla in another column to complete that cell with the word "completed" when the date is added. Im creating an exterior report that i want to show just the info for the completed rows but the only way we know its completed is by this date being added. If the date column is…
-
Drop down on Smartsheet
Hi, I have set the contact to select only from the designated contact list with having their Name preset for their designated email. However, for some reason the person filling out the drop down doesn't see their name as a drop down option. Instead they only see their email listed as an option. How would I fix it on her…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Merged: Conditional Drop Down List Values
This discussion has been merged.
