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
-
Sheet Summary Formula for Due DatesUnansweredFirst post 01/23/20,Last post 01/23/20Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?Formulas and Functions60Heidi Ng -
First post 01/23/20,Last post 01/23/20I have attempted multiple strategies to send multiple rows based on a trigger. The automation only sends the row where the trigger event occurs. Below is the Automation logic, The email that was sent and the data in the sheet. https://us.v…Using Smartsheet40Dale Heincelman
-
First post 01/23/20,Last post 01/23/20Hi, The default behavior when opening a new Smartsheet window or tab appears to be to load the most recently opened sheet. When I have multiple tabs open, this can be a little disorienting — or at least, it costs a little time and effort t…Using Smartsheet50Renny Hart
-
Help with Design/Nested FormulasAnsweredAnswered ferguson_pamela107206 22 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20So I need some help with my design or nested formulas..... I have a formula in a column (listed below) which is perfect, except that in a few instances there are exceptions, and I must add up several different $ amounts from a few CLINS on…Formulas and Functions225ferguson_pamela107206
-
First post 01/22/20,Last post 01/23/20Hello, I'm trying to calculate average work days that each command takes to return a request. However, it has to meet several other stipulations. -"Type of Request" has to include "FOIA" (drop-down column multi-select) …Formulas and Functions195fennerb
-
Automation with Time selectionAccepted AnswerAccepted Answer Sitlaly Avelino 13 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Is there a way to allow a user without access to the smartsheet to select a time and date? We use the automation to send emails out to contractors so that they can give us a work start date. However, we also want to know the exact time of…Formulas and Functions133Sitlaly Avelino
-
Answered Jennie Victoriano 25 views 3 comments 0 points Most recent by Genevieve P. Using SmartsheetFirst post 01/22/20,Last post 01/23/20For each day, I need to indicate date, time, location, class, method, class role, trainer. Any chance I can build something like this in SmartSheet. Thank you in advance. https://us.v-cdn.net/6031209/uploads/238/P1N6H2WD9BNO.docxUsing Smartsheet253Jennie Victoriano
-
Currency Conversion USD to CADAccepted AnswerAccepted Answer PRITIKA SAINI 8 views 2 comments 0 points Most recent by PRITIKA SAINI Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20Hello I am currently using both currencies in my sheet. I created a column drop down, need help with a formula. If I select USD from that column, the amount should be converted to CAD if I select CAD from that drop down column then the am…Formulas and Functions82PRITIKA SAINI
-
Confirmation EmailUnansweredFirst post 01/23/20,Last post 01/23/20I set up a form and when I tested it, I did not get a confirmation email. Why is this?Using Smartsheet40Amy Kolasky
-
Answered Brigette Lepe 19 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20I am trying to have some date fields auto-populate based on some restrictions. Date Columns 2, 3 and 4 would be dependent on Date column 1. For example: An Inspection must always occur at least 2 days after Work Start. If I enter Work Star…Formulas and Functions195Brigette Lepe
-
Importing Data Fields Automaticaaly Changing to CheckboxesAccepted AnswerAccepted Answer Lee Ratzlaff 21 views 5 comments 0 points Most recent by Genevieve P. Using SmartsheetFirst post 01/21/20,Last post 01/23/20Hello, I am attempting to create a new grid by importing an excel file. The data includes 0, 1, and 2 and every time I import the file it turns the fields into checkboxes. I want the raw data displayed, not turned into true/false with rand…Using Smartsheet215Lee Ratzlaff -
How do I calculate a Group Average for the Most Recent Date?Accepted AnswerAccepted Answer Scott Anderson 20 views 3 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20I have assessment scores for individuals within different groups (Male or Female). The assessments are taken over time as a sort of "pulse check." Now, I want to be able show a group average (average for all Males and average for…Formulas and Functions203Scott Anderson
-
E-Form links embedded in Adobe PDF filesUnansweredFirst post 01/23/20,Last post 01/23/20We embedded an e-form URL into an adobe PDF to create a clickable link in an event flyer. We've done this many times in the past, but this time we're getting feedback that the links don't work on Apple devices. After Googling, it seems tha…Using Smartsheet40Kelly Ospina
-
At Risk with % Complete & Dates FormulaAccepted AnswerAccepted Answer lcymr13 21 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Oh formulas. . . I feel like I am close, but could use some help. I would like the 'risk' flag to be marked if the data meets the following criteria: % complete is equal to or less than 50% AND The date is within 3 days; Today; or is in t…Formulas and Functions213lcymr13
-
Question Beth Faircloth 4 views 0 comments 0 points Started by Beth Faircloth Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20All, (Please see screenshot for reference) I am trying to get a "total locations" excluding if "cancelled" is checked. Current formula in "total locations is. =COUNT([Location #]:[Location #]) This gives the total…Formulas and Functions40Beth Faircloth
-
First post 01/23/20,Last post 01/23/20Hello, Can I create an Alert (Alert Someone) that would send a notification to an email for each day when a task is listed as happening in relation to the Start and Finish dates, inputted in the system? The logic cannot be static, and sho…Using Smartsheet70Milton Rodas
-
PrintingUnansweredFirst post 01/23/20,Last post 01/23/20How do I get the task column to print on every page of my 8 page Gantt chart?Using Smartsheet40JTHall
-
Answered Laurence Bergeron 16 views 1 comment 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20for exemple https://us.v-cdn.net/6031209/uploads/220/GBHD6PIX1YDQ.png In my sheet https://us.v-cdn.net/6031209/uploads/059/3CGRABEL8NHU.png i would like in my reponse here https://us.v-cdn.net/6031209/uploads/934/GFSNDQEV6AU6.png corre…Formulas and Functions161Laurence Bergeron -
I need help with nesting syntax pleaseAccepted AnswerAccepted Answer Lisa Kastelic 15 views 5 comments 0 points Most recent by Lisa Kastelic Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20I am trying to count the number of tasks assigned to a resource, let's say "Jane". The COUNTIF function works if there is only one resource in the "Assigned To" category, but I also need to include the number of times …Formulas and Functions155Lisa Kastelic
-
SUMIF based on checkbox columnAnsweredFirst post 01/22/20,Last post 01/23/20This discussion was created from comments split from: How is the checkbox function recognised?.Formulas and Functions144System -
Add Comment Section to a formAccepted AnswerFirst post 01/23/20,Last post 01/23/20Hello, Is there a way to add the comments section to a form? Or a formula to move / copy text from a comments column into the comments section? Thanks! Matt L.Using Smartsheet112mlanterman
-
Answered Keith MacKenzie 31 views 4 comments 0 points Most recent by Robert Allen Premium Apps and IntegrationsFirst post 01/21/20,Last post 01/23/20Hi, I have a query that is looking for all Stories in about 25 epics. In addition I have pulling the 25 Epics via there IDs. I am only getting a some of the rows to come to Smartsheet. I am only pulling to SmartSheet nothing is pushing …Premium Apps and Integrations314Keith MacKenzie
-
First post 01/17/20,Last post 01/23/20Hello, I actually have some #NOMATCH problem, that I can't explain because it work different cells of my sheet that have same parameters. My formula is : =IF(ISBOOLEAN(VLOOKUP([N° CONTAINER]1; {LDS Container Dashboard plage 2}; 21)) = 1; 1…Formulas and Functions237Laurent DESSOLLES
-
Viewing Submitted FormsAnsweredFirst post 01/23/20,Last post 01/23/20Good morning, I'm creating a form that I'd like to be able to save the responses as a PDF document. As far as I can tell, the only way to see submitted forms is through the sheet itself - not in any "document" format that could b…Using Smartsheet71Chris Hockey
-
First post 01/13/18,Last post 01/23/20Does anyone have a template or know of an existing template that could be used for OKR's?Using Smartsheet29612brettwad
-
First post 01/23/20,Last post 01/23/20Hello, I have 2019 monthly data in Sheet 1 and would like for it to be populated in Sheet 2 based on current 2020 month. Basically, I want to pull same month last year data from sheet 1 to sheet 2. I've tried using VLOOKUP in sheet 2 cell …Formulas and Functions120Krishna Patel
-
IF(INDEX(MATCH Function - For Resource TrackingAccepted AnswerAccepted Answer davidmartin95826 10 views 6 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20Hello, I have an Procurement Engagement Form (PEF) and a Resource Tracker. I'm trying to pull the Contract End Date into the Resource Tracker using the Function below. Its working perfectly in Excel, although unfortunately I'm struggling…Formulas and Functions106davidmartin95826
-
First post 01/22/20,Last post 01/23/20Workspace owner can't be removed if they own sheets or dashboards in the workspace. Please ensure all sheets or DB they own are transferred to another owner. It was alot of sheets - is there no bulk way to correct this? The person that mov…Using Smartsheet121Shawn Borror
-
First post 12/20/18,Last post 01/23/20I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…Formulas and Functions888CamCrichton
-
Card View - Conditional FormattingAccepted AnswerFirst post 01/21/20,Last post 01/23/20Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry ove…Using Smartsheet243Gunn_Jack
