Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
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 01/21/20,Last post 01/21/20Hi, Is there a way to lock columns until a cell in a different column changes? Basically I don't want personnel to be able to add text in the "Post AFC Change response" cell until the "LDO QA Check Complete" date is in…Using Smartsheet91sahilhq
-
First post 01/21/20,Last post 01/21/20The only option I found is URL and it needs to starts with http. Any help will be appreciated.Formulas and Functions121Juan Castro -
Report on Last Comment date?AnsweredAnswered Spud Software 27 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/20/20,Last post 01/21/20I'm seeing that the System Modified field is NOT updated after entering a new comment on a row. Is there a way to report on the Last Comment Date? I am trying to identify a way to create a report on my sheet that shows Last Update dates, a…Formulas and Functions273Spud Software
-
Copy a Dynamic ViewAnsweredFirst post 01/21/20,Last post 01/21/20Is there a way to make a copy of a Dynamic View?Using Smartsheet81Mark Slates -
Applying Filter to AgendaAnsweredFirst post 01/21/20,Last post 01/21/20Hello all, I've been using Smartsheet for a few hours and i've been able to create in Gantt Mode without problem so far. The columns i've created allow me to filter tasks and help me read / correct / adjust the planning easily : Nice ! Now…Using Smartsheet81Cyril_H
-
First post 06/26/18,Last post 01/21/20The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tr…Using Smartsheet323hcosta52671
-
First post 01/19/20,Last post 01/21/20This is probably obvious to anyone who has worked extensively with Smartsheet, but as a newcomer imagining how to best use Smartsheet to build efficient and practical solutions, I could use some clarification about the functionality and li…Using Smartsheet251Bradley Berneche
-
First post 01/10/19,Last post 01/21/20Hello! Is there any possibility to have several columns for attachments, not just a staple in the left side? I need to name this separate columns to see if a row is filed with all required attachments or not.Using Smartsheet305DIV
-
Answered Melissa.Holland80446 27 views 11 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/16/20,Last post 01/21/20In our project tracking sheet we have a column for Project/Task Name. The project name is listed in the parent row and then any tasks are listed below as child rows. The projects are added to the sheet by the Director who also assigns a pr…Formulas and Functions2711Melissa.Holland80446
-
Schedule VarianceAccepted AnswerAccepted Answer James Pflueger 21 views 5 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 01/17/20,Last post 01/21/20How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and t…Using Smartsheet215James Pflueger
-
vLookup and AVGAccepted AnswerAccepted Answer styless 37 views 13 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/10/20,Last post 01/21/20Hello, I am trying to do a vlookup to count the average days to fill for each Org Level, by Exempt VS Non-Exempt. This is the source sheet: https://app.smartsheet.com/b/publish?EQBCT=2b4a116ae47c4d17a13c6fea0d751347 Sheet I wanted the Vloo…Formulas and Functions3713styless
-
Create metrics using a Date RangeAccepted AnswerAccepted Answer Shane Cornwell 24 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/16/20,Last post 01/21/20Hello - I am trying to build metrics that show how many projects are created with specific quarters based off a Date completed column. Currently using this formula but it is not working: =COUNTIFS({Project List Range 1}, "Closed"…Formulas and Functions243Shane Cornwell
-
First post 01/17/20,Last post 01/21/20I have formulas used to create target finish dates. What I would like is to have the target finish date show the date based on the formula when the Actual finish date column is blank. But when the actual finish date is populated I would l…Formulas and Functions1911AmandaM
-
Calendar View: Viewing More than one column in calendar viewAccepted AnswerFirst post 01/20/20,Last post 01/21/20Good afternoon, I am trying to figure out how to make more than one column show up when viewing in calendar view, can someone please advise. JPEGS attached for reference https://us.v-cdn.net/6031209/uploads/970/J6VEQHMWPF2L.jpg https://us…Using Smartsheet223BESP10 -
First post 12/07/19,Last post 01/21/20My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count…Using Smartsheet642awollam105821
-
How do I make required fields required on an Android phone?Accepted AnswerAccepted Answer Jeffrey Mikles 11 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 01/20/20,Last post 01/20/20I have created a time reporting collection form with required fields that works fine on my PC, laptop and tablet, but not on my Android phone. I don't have to complete any of the required fields on my phone app in order to submit the form…Using Smartsheet113Jeffrey Mikles
-
First post 09/17/19,Last post 01/20/20How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is…Using Smartsheet393alycia104251
-
Answered Stephanie Stewart 10 views 1 comment 0 points Most recent by Stephanie Stewart Using SmartsheetFirst post 01/20/20,Last post 01/20/20Hello all, I have 3 columns in my Smartsheet List Price, Percentage Discount and Net Price. If the List Price and Percentage Discount are populated for a row, I'd the Smartsheet to determine the Net Price based off List Price and Percent…Using Smartsheet101Stephanie Stewart
-
First post 01/20/20,Last post 01/20/20This discussion has been moved.Formulas and Functions10Alejandra -
Answered xnickeddlemanx 23 views 5 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hi Community, I am working with an INDEX MATCH formula to return content from another sheet; however, for each unique value, there are 4 duplicates. For example, an associate completed 4 learning events all attached to the same cohort na…Formulas and Functions235xnickeddlemanx
-
First post 01/20/20,Last post 01/20/20All: this is to share/record a way to push the submit button in a smartsheet webform using vba. I share this because I spent way more time trying different options posted on different websites than I would like to admit. Dim IE As Object …API & Developers150[email protected]
-
Alerts and actionsAnsweredFirst post 01/17/20,Last post 01/20/20How can i make sure the person i am assigning a task to gets notified immediately?Using Smartsheet165Juley Mathew
-
First post 01/20/20,Last post 01/20/20Good afternoon, Would it be possible to create a product that allows users to do a live search on sheets and even possibly aggregate data from multiple sheets to produce given search results. I have already built this through a customized…Formulas and Functions150Anthony Verhoeven
-
Accepted Answer Sldollman 19 views 8 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hello community! I am attempting to use an IF statement in a contact column to insert a vendor name depending on the company name in the associated row. =IF(Company1 = "Hospitals", "Vendor Name1", "Vendor Name2&quo…Formulas and Functions198Sldollman
-
Archiving a Child row with it's parent row.Accepted AnswerAccepted Answer Hammermill21 21 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hello everyone! I want to set up a workflow where I move a row when it check off as archived. But that row is a child of a parent row. How can I move both the child and parent row from my sheet, but also not actually remove the parent row …Formulas and Functions217Hammermill21
-
Answered Mark Strecker 19 views 2 comments 0 points Most recent by Mark Strecker Formulas and FunctionsFirst post 01/17/20,Last post 01/20/20Hello, I have two columns, one has job numbers in it, and the one beside it has this formula to detect if the first coiumn has duplicates: =IF(COUNTIF([Complete Job Number]:[Complete Job Number], [Complete Job Number]51) > 1, 1). The ro…Formulas and Functions192Mark Strecker -
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet635Sgiovinazzo
-
Formula to have a check box ticked when a date is reachedAccepted AnswerAccepted Answer [email protected] 29 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/16/20,Last post 01/20/20Hello Smartsheet Community, Would anybody know how to write a formula to tick a check box once a date in another column is reached. Many thanks in advance😊Formulas and Functions295[email protected]
-
First post 02/20/18,Last post 01/20/20Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.Using Smartsheet1017KMart
-
First post 01/17/20,Last post 01/20/20https://us.v-cdn.net/6031209/uploads/670/YQNPWNG4G3XF.png I have tried this several times but the filters I create before saving as a template do not appear in the derived sheet. The check box above leads me to believe the filters should …Using Smartsheet131John Laycock
