Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for April 2017
Discussion List
pdf attachments for Droid Ap
I routinely use pdf attachments for my worksheets and my shared collaborators have been able to open the paperclip. On one particular worksheet none of the pdf paperclips are working. The screen is black. This occurs on a smartphone with a droid ap. jpgs open but not pdfs. Is the only solution to resave all of the .pdfs as…
Counting values within a column
Can you count the number of repeat values with a column. For example--building a board roster and want to identify gender. Can I create a formula that counts how many females are in the column at the bottom of the last row of the column? Looking at the formula worksheet it is suggesting =COUNTIF(Female:Female, Female1).…
Keyboard Shortcuts
Is there a published list of supported keyboard shortcuts? eg: insert rows
Copy of standard % Completed column
I'm looking for the option to have 2 columns with % Completed, to compare actual with the baseline. one standard functionality with Actual value, second that I want to create to use as a baseline value Is there a way to copy/create the same column as % Completed ?
Locking a Single Cell
Is there a way to lock a single cell instead of an entire row / column? I do not want to lock the users from entering data on the entire row / column, but I do want to protect a formula(s) in certain cells.
Dark Mode
Can we get a dark mode? something like the dark neutral theme but has dark cells as well so it is easier on the eyes.
formula advise please
hiya, please see screen shots. I have a list of sales people assigned to target new customers. I want to know how many of their target customers are open opportunities (taken from a dropdown) but my summary table is picking up all the companies that have been contacted but are not suitable for any reason. i just need a…
Field/Column Alert
Is there a way to set up an "on screen" alert when a specific text/number is added to a particular column? We use Smartsheet to manage client's jobs as well as deadlines. Some of our client's have a specific template that they would like for us to use and it can be a bit overwhelming when we deal with hundreds of clients.…
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
Attaching OneDrive File
I'm having trouble attaching OneDrive files, but have basically narrowed it down to not being able to attach files that were shared to me from someone else. Problem is my boss creates the main folder then shares it with me and we work like crazy out of that one folder. So does this mean that unless I am the creator and…
