-
Cell Link from web form
Hi, I am trying to link the cell to other sheet, once the data is filled up from the web form. The problem I am facing is, whenever the form is submitted & the data is posted on my sheet, it is being posted below the cell which is linked to other sheet. I used the workout of providing the cell background color to white to…
-
Max number of entries in drop down list?
Hi; Is there a limit to the number of entries in a drop down list? Would a list of 1200-1500 names have an impact on performance? We don't need validation or conditional formatting (e.g. red for a value is entered that is not in the list). Are there best practices for a task like this? Thanks in advance, Andrew
-
Totals by month
Hello, I'm trying to figure out how to get totals by specific month. There are 3 columns I'm trying to pull data from, a monetary column called "Unit Price," a dropdown list column called "Produced," with options that read "1. In Production" and "2. Produced," and a date column. Basically, I want to have a cell that shows…
-
Can smartsheet do this
I'm new here but have watched multiple webinars and read the getting started info. Before I invest a lot of time in this, I'm wondering if smartsheet has the ability to link two sheets with a one-to-many relationship. For my purposes, I'd like to have one sheet of open orders and another sheet of lineitems. There can be…
-
Formula to return Parent name of child?
I'm trying to figure out how to return the name of a child's Parent. Example: Parent 1 * Child 1 * Child 2 * Child 3 Parent 2 * Child 4 * Child 5 In the above, I would love to have a column on Row Child 1 that automatically returns "Parent 1" and for Child 4 returns "Parent 2". Is there a way to have a formula function…
-
Trying to connect a check box column to a completion date column
I am looking to connect a column in which I have a check box indicating done (check) and not done (unchecked). On the same sheet I have a column for Completion Date. I would like the sheet to auto-populate the Completion Date field each time a check box is checked as done. Is that possible?
-
Opening a link to a sheet (Smartsheet), while utilizing the Smartsheet App
I have employees that exclusively operate within the Smartsheet App (iPhone & iPad). The sheets that we are working with, contain hyperlinks to other sheets. Upon opening the link to another sheet, while in the app, it redirects the employee to the web version of Smartsheet...it does not open the link in the app. I am…
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
-
Cell linking within the same sheet
I have a project where I have a start date and due date for each of my tasks, however on a calendar report sometimes I want the start date to show up on the calendar (when it GOES to reviewers) and sometimes I want the due date to show up on the calendar (when the analysis needs to be COMPLETED). I've created a summary…
