Smartsheet Basics

Archives for April 2018

Dynamically Updating Dashboard Using Forms
I currently have a form sending data to a sheet, and then data from that first row displaying on a dashboard that I can print out for a visual representation of project data. Is there anyway that I can choose which row of data I want to show on the dashboard (aka choose which project I would like to visually see)? Thank…
Not able to choose myself from a dropdown menu list
Hi Everyone Just trying to figure out why I can't choose myself for a dropdown menu list. The error reads "Please enter or select a contact from the dropdown list. A sheet admin has restricted this column to dropdown contacts only". With two options, cancel and edit. I am clearly on the dropdown list, but everytime i click…
Multiple Selection on dropdown
Is the ability to select multiple items from a dropdown still in development???
Is there a way to print multiple card views (same as the print from row function)?
Is there a way to print multiple card views (same as the print from row function)?
Create a Form that can go to different people
I am trying to make a sheet and a form that will allow me to notify different people from different departments to make sure they get the correct information. Can this be done and if so how. Please let me know
Automated Reminders showing all dates
I recently noticed that all dates including columns that are hidden are showing with my automated reminders. I have a number of calculated dates that I don't want to display. However, all of them now show on the reminders. This is a fairly recent development. I have emailed "Help" but, they have not responded in over a…
Rows' will not permanently delete
Hello, I right click on the rows at the bottom of my sheet and delete but they keep reappearing. I'm fine with say three but there about 12. These also are printed. can you help?
Project Roll Up
Good Morning, I am struggling with presenting a project roll up including gant in a clean view. I would say a program view is what I was wondering if anyone had some guidance on. Thank you. Lynn
Cell Linking vis-a-vis Predecessor
Dear All, As mentioned I am trying to cell link the Task and the start date. Post to creating the cell link I add a predecessor to the line,however the link to the Start Date disappears? Could someone please help me with this as this is crucial for me to maintain my Master Plan and Deliverable, dependency tracker. Many…
Freelance Consulting
Hello all, I have been using smartsheet for about a year and I am all in. As Nerdy as this may sound, I enjoy using smartsheet to create solutions, as I have done, still doing, for my insurance agency. I would enjoy having a business, helping other businesses reach efficiency, using smartsheet. Is there any rule or…

Trending in Smartsheet Basics

Add values after form is created
After a form is shared with someone else, is it possible that they add a value in another cell?
referencing cells
Hello, I have notice anytime I try to reference a column in a formula it doesn't automatically recognizes the name and then I always get the unparseable error. For example in below I want Smartsheet to calculate all the item listed as test under the column implementation Manger. =COUNT(Implementaiton Manager:Implementation…
Date with in a sentence
I get data loaded that has a text with it. I want to write a formula to pull the date out. Trying to use this formula, but getting #UNPARSEABLE =VALUE (LEFT ([Daily Rain Total]@row, FIND (" ", [Daily Rain Total]@row)-1))

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List