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
-
Announcement Anna Mkrtchyan 60 views 1 comment 0 points Most recent by [email protected] Using SmartsheetFirst post 08/05/20,Last post 08/07/20Join us on August 13th for a free webinar, Work seamlessly with Smartsheet and Microsoft 365 integrations. Increase productivity and real-time collaboration with our Microsoft 365 integrations. In this webinar, we'll share how your organi…Using Smartsheet601Anna Mkrtchyan -
Join the new group for Control Center!AnnouncementAnnouncement Brian Besand - Smartsheet 53 views 0 comments 3 points Started by Brian Besand - Smartsheet Premium Apps and IntegrationsFirst post 07/29/20,Last post 07/29/20We've launched a new group for Smartsheet Control Center users! We hope this is a space for you to find answers to your questions, provide help to others, and connect with people with similar interests and use cases. Ask you questions abou…Premium Apps and Integrations530Brian Besand - Smartsheet -
Announcement Stephanie Boulanger 108 views 0 comments 0 points Started by Stephanie Boulanger AnnouncementsFirst post 07/21/20,Last post 07/21/20Join achievers worldwide for this re-imagined, innovative virtual experience. Register by July 31 and you'll get to vote on the top five sessions you think we should add to the agenda. Learn more and register for the event!Announcements1080Stephanie Boulanger -
Smartsheet Virtual Zoom Backgrounds Anyone?AnnouncementFirst post 07/09/20,Last post 07/09/20Who's ready to spice up their Zoom meetings with some new virtual backgrounds? We are posting them here on Community first! We have Community virtual backgrounds (my favorite) as well as MP4/GIF slow moving video backgrounds. Follow the…The New Work/Life Reality5730Shauna Wu
-
Using COUNTIFSQuestionFirst post 08/09/20,Last post 08/09/20Hi, I am using the following formula to count those occasions when CSOD (unit) is impacted by CFCD (unit) and the status of the impacts is either 'conceptual' or 'complete' and it does not work. If I limit it to only counting 'conceptual'…Formulas and Functions50Phil Wightman -
Answered - Pending Review Tamizamuthan Vedachalam 22 views 9 comments 1 point Most recent by Alyssa Feola Using SmartsheetFirst post 08/03/20,Last post 08/08/20Hello Experts, I am writing a workflow to copy and paste a particular Column value from 1 sheet to another sheet. However, the workflow is copying the entire column details from the spreadsheet.Using Smartsheet229Tamizamuthan Vedachalam -
Question Cristina Andersen 6 views 0 comments 0 points Started by Cristina Andersen Formulas and FunctionsFirst post 08/08/20,Last post 08/08/20Hi all, here's my scenario. I have four sets of cars that get moved out of my location. They come sporadically throughout the month. Im trying to figure out a formula that would average the turn time on a particular set of cars. Any ideas?…Formulas and Functions60Cristina Andersen -
Form Default rangeQuestionAnswered - Pending Review Smartsheet User 28 views 7 comments 0 points Most recent by Smartsheet User Using SmartsheetFirst post 06/13/20,Last post 08/08/20Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of…Using Smartsheet287Smartsheet User -
First post 08/08/20,Last post 08/08/20Hi guys, I'm a new Smartsheet partner trying to develop a custom solution for a client. So the client requests Dashboard with up to date leaderboard on it. I've made the leaderboard and connected it to other data so it calculates victories…Formulas and Functions90Leonard Eldić
-
Answered - Pending Review Cara Fagerholm 5 views 1 comment 0 points Most recent by Sean Morgan Using SmartsheetFirst post 08/07/20,Last post 08/08/20The data type of one of my columns is repeatedly converted to a “Date” data type from a "Dropdown (Single Select)" column type. When I return the data type to a single-select checklist, it is repeatedly converted back to a date d…Using Smartsheet51Cara Fagerholm
-
Answered - Pending Review Erin Becker 9 views 1 comment 0 points Most recent by Sean Morgan Formulas and FunctionsFirst post 08/07/20,Last post 08/08/20Hello there, I have a sheet setup with 4 columns of dated. Project Owner Completion Deadline, Project Owner Actual Completion Deadline, Project Auditor Completion Deadline, and Project Auditor Actual Completion Deadline. I am trying to fi…Formulas and Functions91Erin Becker
-
Answered - Pending Review Kevin Smith 7 views 1 comment 0 points Most recent by Sean Morgan Using SmartsheetFirst post 08/06/20,Last post 08/08/20On a sheet, when I open an attached PDF, I get a link starting with https:// to that PDF. I want to use that URL on a dashboard but when I try to use it, I get the following error. (Image) This doesn't seem valid to me as I have no restri…Using Smartsheet71Kevin Smith
-
Answered - Pending Review saraha83081 14 views 2 comments 0 points Most recent by lewis hamilton Formulas and FunctionsFirst post 08/07/20,Last post 08/08/20Hello, I'm trying to create a formula that will display a specific value if a date falls within a certain range. Any assistance would be greatly appreciated. If “Target Update or Replacement Date” is between 10/01/20 and 09/30/21, then &…Formulas and Functions142saraha83081
-
Answered - Pending Review Olivia Gannon 15 views 2 comments 0 points Most recent by lewis hamilton Using SmartsheetFirst post 08/07/20,Last post 08/08/20can you automate smartsheet with sharepoint?Using Smartsheet152Olivia Gannon
-
First post 08/07/20,Last post 08/08/20I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of…Using Smartsheet71Kevin McIntosh
-
Count completed dates once from two columns counting only the most recent competion date by weekQuestionAnswered - Pending Review Lynn Strahm 9 views 2 comments 0 points Most recent by lewis hamilton Formulas and FunctionsFirst post 08/07/20,Last post 08/08/20I'm trying to count the number of quotes completed by week. The challenge is there are two departments who may work on a quote and each enter their own completion date. Sometimes only one department works on a quote so only one of the tw…Formulas and Functions92Lynn Strahm
-
Answered - Pending Review Jean-Robert Adrien 9 views 1 comment 0 points Most recent by lewis hamilton Using SmartsheetFirst post 08/07/20,Last post 08/08/20I used to see the login history of the users in my organization. Unfortunately once I deleted a user I cannot see their login history anymore. How should I go back and retrieve the history of actual and former smartsheet users of my organi…Using Smartsheet91Jean-Robert Adrien
-
Answered - Pending Review paulen 12 views 2 comments 1 point Most recent by Sean Morgan Using SmartsheetFirst post 08/07/20,Last post 08/08/20Very strange! The conditional formatting of one of my spreadsheets just disappeared. I open the configurator and it is empty. Some settings are being applied but most are gone! I am the only one allowed to change and nothing has changed. I…Using Smartsheet122paulen
-
Multiple tasksQuestionFirst post 08/08/20,Last post 08/08/20Hi all, Why can't we do multiple tasks at once time: share all the sheets to one person (because can't share workspace) or to save as a new sheet to all folders/workspace? Thank you.Using Smartsheet60Thao Tran Phuong
-
Share-folder of workspace onlyQuestionFirst post 08/08/20,Last post 08/08/20Hi all, I'm just wondering why we can't share folders of workspace to collaborators. I only can share workspace or share sheets only. Some people only need to see sheets in one folder and it's really inconvenient. Thank you.Using Smartsheet70Thao Tran Phuong
-
Help With Index/Match!?Accepted AnswerAccepted Answer Neil Fleming 18 views 7 comments 0 points Most recent by Neil Fleming Using SmartsheetFirst post 08/05/20,Last post 08/08/20Man, this is frustrating! I've devoted a fair bit of time perusing all of the posts, but haven't been able to get this right yet. I've created a couple of sheets to act as training examples...the main one having products in one column, an…Using Smartsheet187Neil Fleming
-
First post 02/22/18,Last post 08/08/20Hi There- I am trying to show a bar chart with 2 data points comparing $ amount of actual to budget. The Chart is not Starting at $0 it is starting at $800K so the data looks weird. Can I choose the scale - say my 2 data points are $…Using Smartsheet63613Jim Schaffhausen -
laura.buchanan 1.8K views 23 comments 0 points Most recent by Andrea Antillon Formulas and FunctionsFirst post 09/16/18,Last post 08/08/20Can anyone tell me what might be wrong with this formula? I'm trying to count the number of items that are complete, as noted by the presence of a date in the date completed field. I need to know the number of fields that have a date in 2…Formulas and Functions178423laura.buchanan
-
Answered - Pending Review Enes Zorkul 15 views 2 comments 0 points Most recent by Enes Zorkul Using SmartsheetFirst post 08/05/20,Last post 08/08/20Hi- While using the automated approval process, users are getting additional e-mail after they approve the request. Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose.…Using Smartsheet152Enes Zorkul
-
Question aschneiderheinze74206 9 views 0 comments 0 points Started by aschneiderheinze74206 Formulas and FunctionsFirst post 08/08/20,Last post 08/08/20I have two Sheets, one with a list of full course master names (e.g., ABS-435-BL-6W-1D-Master), and another sheet with a list of course sections (e.g., ABA 435 BL 6W). Is there a way to use CONTAINS in a cross-reference formula to check al…Formulas and Functions90aschneiderheinze74206 -
Automate UAT Test ScriptQuestionFirst post 08/08/20,Last post 08/08/20I am looking for a way to create a test script using forms. Multiple users would complete the script which would populate a single sheet that could be reported off...... If a tester completes a step in the script (form1), they would subm…Formulas and Functions60Sandra Healey
-
First post 11/12/18,Last post 08/08/20Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing sam…Using Smartsheet2486irene
-
First post 08/23/19,Last post 08/08/20We're going into UAT soon. I've chosen Smartsheets to put all the test cases the testers need to run. Some things I'm wondering about - hopefully all of you ppl smarter then me can help: 1. I imagine that I will need multiple sheets right…API & Developers992laneski
-
Answered - Pending Review Chad Dixon 19 views 2 comments 1 point Most recent by Lorraine Metler Formulas and FunctionsFirst post 07/15/20,Last post 08/07/20Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding miles…Formulas and Functions192Chad Dixon
-
Checkbox Column + % Complete Column FormulaAccepted AnswerFirst post 08/07/20,Last post 08/07/20Smartsheet I am trying to use this Formula to calculate % Complete based on Checkbox, however the Checkbox is a different Column Called Done, not under the % Column. Can I do that? Existing Formula: =ROUND(IF(COUNTIF(DESCENDANTS(), 1) / CO…Formulas and Functions94Ray B
-
First post 08/07/20,Last post 08/07/20I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much ins…Using Smartsheet80elektra_h
-
First post 08/07/20,Last post 08/07/20Hello, Our company is going through a name change and with this our domain is changing also. I am wondering if there is anyway that we can bulk add their email with the new domain on it as an alternate email.Using Smartsheet70Nick Champlin
-
Answered - Pending Review KBeem 10 views 1 comment 0 points Most recent by [email protected] Using SmartsheetFirst post 08/07/20,Last post 08/07/20I use forms for surveys a lot. I'd like to be able to use a video to ask a question. For example, if the survey is for the CEO, I'd like to video the CEO actually asking the question. Also, I'd also like to refer to graphs in my question…Using Smartsheet101KBeem
