-
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.
-
Update "Symbol" Set to Accommodate Color Blindness
Hi there. Two people at my current client are color blind. When using the Red/Yellow/Green/Gray "Symbol" set in a sheet, I learned all the colors in this symbol set appear as grey to them: Changing the colors (darker reds/maroons and 'golder' yellows work to provide variation), or adding a letter to the center of the…
-
Two column types in one column work-around - #DATE EXPECTED error
Hi, I'm in the process of transferring a spreadsheet into smartsheet that splits costs by months, and I've ran into a #DATE EXPECTED error for my formula. I can't change the column type as the formula itself requires the cell above to be a date. Does anyone know if there's any work-around? Here's the formula:…
-
Help! Summary Sheet Data Not Linking
I recently changed two column types from Text/ Number to Date columns in my summary sheet and when I created a new project I got the following message… Does anyone know how I can fix this to ensure the data links in to my summary sheet correctly?
-
Columns keep collapsing at each reopen
Hi Every time I open Smartsheet I have to manually resize each column to show all columns as well as to fit the entire sheet to my screen. This also happens when I switch to another application and then switch back to the Smartsheet and I have to redo it over again. So boring! Is there any way to tell Smartsheet to keep…
-
Can you restrict columns to write only time/contact?
I know that we are able to restrict columns to write contacts only. However, for some reason even if I have the contacts listed, they still write down their email instead of selecting the contact drop down lists. Why is it not restricting properly? How would you restrict a certain column for the person to input time only…
-
Indenting Auto Number Column Type in Smartsheets
I have created a Bug & Issues log for a project I'm working on. Within that sheet I have a column for "Store #". There are many instances where different stores have the same issue and I want to be able to report on that information. Right now, if multiple stores have the same issue, people are just adding the store…
