Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
First post 11/03/19,Last post 04/29/20Hi! I have not found this topic discussed yet. We'd like to do a couple of things with our intake forms. 1. Make the intake fields conditional. Some surveys are set up so that what you chose in field A. will affect what you see for the fi…Using Smartsheet1654Tom.Richards -
First post 11/06/19,Last post 04/29/20Hello! I have a form that allows users to select up to 5 types of shirts. I want to be able to limit the amount. So if for the green shit they select 3 shirts, for the red shirts I want them to only be able to select up to 2, and that wou…Formulas and Functions663Hammermill21
-
First post 06/13/18,Last post 04/29/20I am trying to create a vehicle order form and want to limit drop down responses based on the answer to a previous question. Example: Truck Type: Pick-Up Truck, Box Truck, Flatbed Manufacturer: Ford, GMC, International, Kenworth, Mack …Using Smartsheet16274DaveDesiderio
-
Logic and summaryAccepted AnswerAccepted Answer dave.mcpherson56751 41 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/28/20,Last post 04/29/20Hi, We have 400 locations managed by approx 30 managers. I am trying to use logic to build a form that when manager 1 chooses their name they only see sites relating to them. To achieve this i have created columns with a drop down for eac…Formulas and Functions417dave.mcpherson56751
-
First post 05/31/19,Last post 04/29/20Hi, New to Smartsheet, is it possible to link fields on a form based on conditions i.e: - If user selects 'Production' from the field 'Employment Department' then mandatory that must select a 'Production Shift' (i.e. one of following Gr…Formulas and Functions6047[email protected]
-
Conditional Logic in FormsAccepted AnswerAccepted Answer mcooke44141 2.7K views 38 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/11/18,Last post 04/29/20Hi SmartSheet Community, I'm looking to use conditional logic in forms. Can someone update me as to it's availability? Has it been implemented yet? I've read this discussion and posted my question there but got no response: https://com…Using Smartsheet265438mcooke44141
-
FORMAccepted AnswerAccepted Answer Archie Villa 23 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 04/21/20,Last post 04/29/20Hello is it possible to create something like this in forms? (Image) Thank youFormulas and Functions235Archie Villa
-
Answered - Pending Review shelley.hose90756 5 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 04/29/20,Last post 04/29/20I'm very new to smartsheets but am trying to create a form so that when a field is selected (ie, customer) the second field (ie, score) will populate based off data in my smartsheet. The first field (customer) is a drop down field and the…Formulas and Functions51shelley.hose90756
-
Report row limitationQuestionAnswered - Pending Review Aspasia Kalomoiri 42 views 6 comments 0 points Most recent by Aspasia Kalomoiri Formulas and FunctionsFirst post 02/19/20,Last post 04/29/20Hi all, I have noticed that there is a row limitation in the reports that i am generating. I have read that there is not such a thing, but it is happening with my reports. It seems that is limited to 392 rows only. Can you please help? I…Formulas and Functions426Aspasia Kalomoiri
-
Rolling scheduleQuestionAnswered - Pending Review Kelly S 33 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 04/27/20,Last post 04/29/20Hi I couldn't find a template so I thought I would ask for suggestions or advice before I create this sheet. I'm guessing the expertise in this group would help me make the sheet better than I would on my own!! What I need: I need to sched…Using Smartsheet331Kelly S
-
Answered - Pending Review Samuel Leroy 27 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 04/22/20,Last post 04/29/20Hi, I would like to know the way to manage "Quality Checks" into a planning with Smartsheet. Ex : Task 1 Task 1.1 Task 1.2 -> related to a specific Quality Check Task 2 Task 2.1 .. I want to manage on t…Using Smartsheet271Samuel Leroy -
YES/NO or just YESQuestionAnswered - Pending Review Dorcas Spencer 24 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/28/20,Last post 04/29/20Yes/No questions - is it better to just have a box to check if the answer is Yes or to have two options a Yes and No option? Welcome your thoughts/ideas on this one as I'm hoping to get two groups to agree on one method. Thanks.Using Smartsheet244Dorcas Spencer
-
Answered - Pending Review Daniel Young 21 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/29/20,Last post 04/29/20I have a task that spans a weekend. It does the correct calculation for the correct number of working days, but in the calendar it's a bit misleading for our team. It makes it appear as if the task is being worked on during the weekend. …Using Smartsheet211Daniel Young
-
Gov connection in Power BI?Accepted AnswerAccepted Answer Jamie Bedford 20 views 1 comment 0 points Most recent by Genevieve P Premium Apps and IntegrationsFirst post 04/27/20,Last post 04/29/20Is there a way to make Smartsheetgov data available in Power BI? The existing Power BI Smartsheet app/connector only seems to connect to a Smartsheet account, but not a Smartsheetgov account, and I don't see any way to customize it to cha…Premium Apps and Integrations201Jamie Bedford
-
Which Template Set is Better: Project Schedule Management or Project Tracking and Rollup?Accepted AnswerAccepted Answer Paige Luben 51 views 2 comments 0 points Most recent by Paige Luben Using SmartsheetFirst post 04/28/20,Last post 04/29/20I am launching a new project with 13 working groups and many dependencies. Do one of these template sets function better under these parameters?Using Smartsheet512Paige Luben
-
First post 03/24/20,Last post 04/29/20Hey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear …The New Work/Life Reality44314Hunter Reed -
Vlookup or match index?QuestionAnswered - Pending Review Joe Suh 38 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 04/28/20,Last post 04/29/20Hi there, I'm wanting to know how to autopopulate the [Supplier Rep] column when a particular [Supplier Name] is chosen (Image) I already have a list in a different sheet to reference from as (Image) what would be the correct formula?Formulas and Functions384Joe Suh
-
How can I get a due date to automatically populate in a cell 10 days from the day a row is created?Accepted AnswerAccepted Answer Brandt Monette 27 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 04/28/20,Last post 04/29/20We currently use a sheet to track warranty construction items. A form automatically creates a new row under our warranty sheet with columns such as due date, claim number, item, address, name, email and so forth. When this row is created b…Formulas and Functions273Brandt Monette
-
Answered - Pending Review Christine Rosenberg 17 views 6 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/29/20,Last post 04/29/20I want my users to start on a specific dashboard, when they sign in. How / where can I set this SmartSheet item as a start object?Using Smartsheet176Christine Rosenberg
-
Answered - Pending Review Jamie Bedford 31 views 2 comments 0 points Most recent by PPS Solutions Using SmartsheetFirst post 04/25/20,Last post 04/29/20Hi there, Is there a way to create a new custom column type? For example, I'd like to create a column type "Department" which would be a drop-down that would be populated with a managed list of official department names. Ideally,…Using Smartsheet312Jamie Bedford
-
Averages and CountsQuestionAnswered - Pending Review Wendy Young 13 views 1 comment 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 04/24/20,Last post 04/29/20I'm trying to obtain the average percentage of completion of the goal progress for all the goals associated with a specific team member. Please help! :) This is the formula I'm using: =AVERAGEIF([PROJECT TEAM]:[PROJECT TEAM], [GOAL PROG…Formulas and Functions131Wendy Young
-
Answered - Pending Review Kathryn Tran 16 views 4 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 04/14/20,Last post 04/29/20(File) (File) I allocated 100% allocation for the same resources in both projects as an example, projects CMDB and GXP Shutdown. How come I didn't see the red flag in column "Risk" to indicate that the resources are over allocat…Using Smartsheet164Kathryn Tran
-
First post 04/28/20,Last post 04/29/20We would really like to have the same search/autocomplete functionality in dropdown lists in Dynamic view as we have in the main sheets. It is really a pain to have to scroll through the entire list.Using Smartsheet321Jacob Edmond
-
First post 09/10/19,Last post 04/29/20Hello, First of all thanks for helping :) I have this list of tasks where i use my WFIndex + Index columns to identify them and execute automations. My Milestones are "locked", colored in blue and in this case identified…Formulas and Functions2027Roger
-
Move select column data to new rowAccepted AnswerAccepted Answer Tracy Huang 19 views 2 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 04/23/20,Last post 04/29/20I have a Smartsheet form that allows employees to request up to 5 unique dates and times (to come on campus). For these dates and times, I have columns: Date1, Time1, Date2, Time2, etc. Ideally, I'd like to have one column of date and one …Formulas and Functions192Tracy Huang
-
How To Identify Max ValueAccepted AnswerAccepted Answer Kamil Ismail 34 views 3 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 04/23/20,Last post 04/29/20Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of …Formulas and Functions343Kamil Ismail
-
Answered - Pending Review sistecompanama74176 26 views 4 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 04/25/20,Last post 04/29/20I have an Work Orde column. but usually maybe I repeat a value for make a task under a project line. I need a formula to identificate it and dont have duplicate rows with duplicate info.Formulas and Functions264sistecompanama74176
-
How can I identified changes made to a column properties.Accepted AnswerAccepted Answer jpagan03101416 4 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 04/28/20,Last post 04/29/20I checked the activity log and I cant find who made the last change to a column property. I wanted to know who added a category in the drop down list menu. Thanks in advanced.Using Smartsheet41jpagan03101416
-
Answered - Pending Review Kristin Behrend 14 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 04/28/20,Last post 04/29/20(Image)Formulas and Functions141Kristin Behrend
-
First post 01/23/19,Last post 04/29/20OK sleuths, this one is for you. We are an organization that loves powerpoint, and no matter what dashboards we create, a powerpoint presentation is typically still needed. We need a way to consolidate our project status in one easy docum…Premium Apps and Integrations6327Tana Perkins
