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
-
Do you need help or want to help others with challenges your organization is facing with COVID-19?AnnouncementAnnouncement Tasha Bishop 204 views 3 comments 3 points Most recent by Michael Coffman The New Work/Life RealityFirst post 03/26/20,Last post 03/28/20Hi Smartsheet Community! I am Tasha Bishop, and I lead the Customer Success organization at Smartsheet. Though we are all facing unprecedented challenges in this new reality in light of the COVID-19 pandemic, I have been touched by how the…The New Work/Life Reality2043Tasha Bishop
-
Announcement Hunter Reed 162 views 10 comments 0 points Most recent by Dave Gordon The New Work/Life RealityFirst post 03/24/20,Last post 03/27/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 Reality16210Hunter Reed -
New COVID-19 Response Resource!AnnouncementAnnouncement Stephanie Boulanger 248 views 1 comment 1 point Most recent by Dave Gordon The New Work/Life RealityFirst post 03/23/20,Last post 03/25/20The Smartsheet team has recently launched the COVID-19 Response Resource Center. This page is a centralized hub where we will surface various resources to help your team with crisis support. This hub has template sets, community and suppor…The New Work/Life Reality2481Stephanie Boulanger -
First post 05/18/19,Last post 03/28/20Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODA…Formulas and Functions602majdesber -
Logic and summaryUnanswered QuestionQuestion dave.mcpherson56751 8 views 0 comments 0 points Started by dave.mcpherson56751 Formulas and FunctionsFirst post 03/28/20,Last post 03/28/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 Functions80dave.mcpherson56751
-
Accepted Answer Daniella Canada 19 views 2 comments 0 points Most recent by Daniel Hampshire Formulas and FunctionsFirst post 03/18/20,Last post 03/28/20We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't fig…Formulas and Functions192Daniella Canada
-
Need help with creating aging buckets.Unanswered QuestionFirst post 03/28/20,Last post 03/28/20Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…Formulas and Functions40Iris Fuentes
-
How to create a Line Chart to automatically include data from new rows entered in a sheet.Answered QuestionAnswered Mohammed Sulaiman 14 views 2 comments 0 points Most recent by Mohammed Sulaiman Using SmartsheetFirst post 03/25/20,Last post 03/28/20I'm trying to create Line Chart widget on a Dashboard, to automatically update itself as the rows are added into the source sheet. How this was set up: In the original data sheet, the actual and expected performance of a parent level task…Using Smartsheet142Mohammed Sulaiman
-
In automatic reply, It's possible to add any images in customize reply.Unanswered QuestionFirst post 03/28/20,Last post 03/28/20working in auto reminder / alert someone workflow automation. In customize reply it is possible to add any image or pics in mail body.API & Developers70Yashwant Singh
-
First post 03/28/20,Last post 03/28/20Status - Column Heading Open - Drop Down Closed - Drop Down CIT - Drop Down Wanting to count how many "open"Formulas and Functions110Mike Boyer
-
Is there a way to have a contingent question on a form?Answered QuestionAnswered Kendra Roach 10 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20I am wondering if I can have a secondary question become "live" on a form based on an answer to a question?Formulas and Functions101Kendra Roach
-
Can I turn off the "Used in formula on" information screen?Accepted AnswerAccepted Answer Sonny Mendoza 10 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?Formulas and Functions103Sonny Mendoza
-
Limit to Dropdown values?Answered QuestionFirst post 03/27/20,Last post 03/27/20We're creating a sheet where we want to have a column of a dropdown single select type. What is the limit to the number of values? For example, we have hundreds of departments we want to choose from, but have the submitter choose one from …Using Smartsheet118jmpbell
-
nested countif with date criteriaUnanswered QuestionFirst post 03/27/20,Last post 03/27/20I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas? https://us.v-cdn.net/6031209/uploads/…Formulas and Functions40Kasey Bernard
-
Average if contains a specific wordAccepted AnswerAccepted Answer Sylvia Elizabeth 14 views 6 comments 0 points Most recent by Sylvia Elizabeth Formulas and FunctionsFirst post 03/20/20,Last post 03/27/20Hi! I'm trying to type a formula which could tell me the percentaje of the cells that are in color green, those cells are painted in green when I type the word "Listo", so I found that formula (showed in the image) in the communi…Formulas and Functions146Sylvia Elizabeth
-
Cross-Sheet Duplicate CheckboxAnswered QuestionFirst post 03/27/20,Last post 03/27/20I have found a few things via smartsheet community on this but I just cannot get this formula to work. I am working fast and furious, so maybe I'm missing something obvious. I am trying to look up a badge number from one sheet and match …Using Smartsheet72Christina Riot
-
Choosing the right criteria for row reports?Unanswered QuestionFirst post 03/27/20,Last post 03/27/20I am trying to create a report that pulls specific rows from multiple sheets (that are similar in structure) into a high level overview that shows: Opportunity Name SKU Adjusted Count Shipped Remaining Target Arrival Date I've pasted an …Using Smartsheet60Mark Silvester
-
FormsAnswered QuestionFirst post 03/27/20,Last post 03/27/20Hello, Is there a way to create a form where fields are displayed in multiple columns? If not, is there a way to publish a sheet where all data inputs are cleared upon exit? Thanks much!Using Smartsheet112Kevin Minkoff
-
IF and HAS and OR formula combined (or alternative)Unanswered QuestionFirst post 03/27/20,Last post 03/27/20Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X…Formulas and Functions40Morgan Frost
-
Data Uploader - if value exists on input file, need it to update status field on source sheetAccepted AnswerAccepted Answer Christina Reid 29 views 4 comments 0 points Most recent by Christina Reid Formulas and FunctionsFirst post 03/12/20,Last post 03/27/20We have tracking sheet that we use to track client accounts that are transferring. I want to take a different file that shows accounts that have confirmed been transfer and use Data Uploader to have the information on the input sheet eith…Formulas and Functions294Christina Reid
-
Formula using <>Answered QuestionAnswered Laurie Bearden 11 views 5 comments 0 points Most recent by Laurie Bearden Formulas and FunctionsFirst post 03/27/20,Last post 03/27/20I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [T…Formulas and Functions115Laurie Bearden -
Range with multiple columns with COUNTIFSAnswered QuestionFirst post 03/27/20,Last post 03/27/20One range in my COUNTIFS formula has several columns included. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. (#Incorrect Argument Set). I then split all these columns in …Formulas and Functions111Al ISS
-
Need to create a "shift" column from a time columnAnswered QuestionFirst post 03/26/20,Last post 03/27/20I have a column with the time (hh:mm) an interaction took place. I have another (currently blank) column for shift that I need to populate from the time. The "shift" during which an interaction took place would be: 7Am-12:59…Formulas and Functions1710Mommaduck
-
Help with cross sheet references.Unanswered QuestionFirst post 03/27/20,Last post 03/27/20Good morning, I am looking to pull the data in a cell if two other criteria are met in other cells in the same row. for example, I have a sheet called Daily reporting that is receiving form submissions. I want to pull the text in [Qualit…Formulas and Functions90Dave Moe
-
Integration with DevOpsAnswered QuestionAnswered sbrelage 11 views 1 comment 0 points Most recent by Alejandra Premium Apps and IntegrationsFirst post 03/26/20,Last post 03/27/20I'm looking for some help setting up my integration from Azure DevOps to Smartsheet. Anyone have experience with that integration?Premium Apps and Integrations111sbrelage
-
Digital signaturesAnswered QuestionFirst post 03/26/20,Last post 03/27/20We have internal digital signatures through our Microsoft CA server. Is it possible to have a field in smartsheet that would accept and store a signature?Using Smartsheet111Mike Sagel
-
Answered k.lakshminarasimham38821 11 views 2 comments 0 points Most recent by k.lakshminarasimham38821 Using SmartsheetFirst post 03/27/20,Last post 03/27/20I have an automated workflow that runs on an action item log daily. There are multiple owners across tasks, do we have an option of sending it out as one? That way the owners won't have to go into individual forms?Using Smartsheet112k.lakshminarasimham38821
-
Scrolling a dashboard inside an iFrame on iPhone - not workingAnswered QuestionFirst post 03/24/20,Last post 03/27/20Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…Using Smartsheet282Dan Snodgrass
-
Answered Melissa P-B 42 views 19 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 03/12/20,Last post 03/27/20Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…Formulas and Functions4219Melissa P-B
-
First post 03/27/20,Last post 03/27/20Hello I have a Task B that cannot start before Task A was finished and that should finish the same time as Task C. When I enter 2 predecessors for B, namely that Task A has FS and Task C has FF, the smartsheet always takes into account o…Using Smartsheet167Tibor Staub
-
IF Formula IssueAnswered QuestionFirst post 03/27/20,Last post 03/27/20Hey all! This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High" =IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, =…Formulas and Functions123NBudd
