-
Merged: Conditional Drop Down List Values
This discussion has been merged.
-
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…
-
What formula would I use to pull text into a new column?
I want to use a formula to isolate the training type into a single column. Currently, "Training Type" is a primary column so I am unable to make it a dropdown selection and automation would take too long to do (there are over 100 rows). So I want to use a formula to isolate the training type from the "Business Segment, RCM…
-
Increase Import Column Capacity
Currently it will not let you import anything that exceeds 400 columns. This is very frustrating when your trying to import data into a sheet. I have found myself having to copy & paste the data in by hand. Increasing the capacity would be extremely helpful. I am transitioning all our excel files into Smartsheet sheets to…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula? This is what I have: And this is the message that pops up when I try to convert it to a column formula: I like the current formula because it allows me to set up my Request…