-
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…
-
Assigned to column with avatar only setting
Hi! The assigned to column works well, and I like seeing everyone's name. However, it would be very helpful to have a "quick indicator" nearer to the project name as to who is assigned this task (or to update the column without scrolling over to the assigned to column). It would be nice to be able to choose an "avatar…
