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

Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…

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

Watch video

Smartsheet Basics

Discussion List