-
Inserting New Columns and copying formatting
I have a sheet where I need to add some more columns in the middle, however when I go to insert the columns, the formatting and coloring of the cells follows the columns at the end of the sheet, rather than those on either side of it. Does anyone know how to make it so that when you hit "Insert Column Right" or Insert…
-
Sync cells content according to date in different sheets
Hi there, I'm new to Smart Sheets and I'm trying to achieve the following. I'll try to explain. I have manually created a calendar, in normal grid mode, which has a 3 month view side by side with blanck cells next to each day where i can manually add content. I have another sheet, in card mode, where I can manage basic…
-
Enhancement Requests: Templates
I needed a better platform to describe what I want: See it there: http://ronin-global.com/2018/08/01/smartsheet-enhancement-requests-for-templates/ Comment here. Thanks. Craig
-
Link View By & Levels Dropdowns
I am trying to setup a a card view with two main View By filters; (1) by assignee, and (2) by project type. When using (1) I would like the Level drop down to be All Levels, but for (2) I would like the Level drop down to be only Level 1. Is there a way to have this happen automatically, since it doesn't make sense for…
-
Bar Code Scanning for event registration
I am an event coordinator, and use Smartsheet mainly for managing my events. It is a great tool for keeping track of to do lists, timelines and event details. I even use it to collect RSVPs. What I'm wondering is if anyone here uses Smartshee's bar code scanner for event check-ins, or if anyone uses a third party…
-
Conditional formatting calendar in cell.
Hi, is there a way to set a minimum date in a drop down calendar in each cell? In my case I have a calendar drop down in a cell where my user can select a date to be completed. However, I would like to set the available dates to no less than 2 weeks. Hope that makes sense.
-
Using Reports / Dashboards for Analytics Recaps?
Hey there! I'm currently tracking our sales analytics using a smartsheet. Column A lists all of my metrics and then i create a column for each week. As the weeks progress, i fill in the rows with sales data. I'd like to create a Dashboard that shows me the data from the last column (most recent week ending) on this…
-
Easy Question : % Complete
Hello, How do I get my % data to roll up to 100? Its looking like all of the data is running up to 1. Does that make sense? Sorry for the hopefully easy questions. Thanks - Alex
-
Dynamic Webform Questioning
Is there a way for a SS Webform to present specific questions based on answer provided in previous questions? For example: * Q1. Did you like ice cream? (Yes/No) * Q2. What is you favorite flavor? Q2 would be asked only if the answer to Q1 is "Yes"
-
Report into Word Doc, remove gridlines
Hi, I created a document automation sheet that produces an end document via a report that I built. I can export the Report into a pdf, but I need to have it as a Word file that can be reviewed and red-lined with comments. I can open the pdf in Adobe and then convert it to a Word doc, but that is an extra step that kills my…