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.
functionality
Discussion List
-
First post 02/17/20,Last post 02/17/20Hey guys, thanks in advance for you help. I have three sheets that I am working with: a database (of sorts), a grid-form summary sheet, and sheet that contains attributed values. To simplify, I will only use a, b, c, and d as production po…Formulas and Functions120Nate Benn
-
First post 02/11/20,Last post 02/17/20Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: https://us.v-cdn.net/6031209/uploads/838/W1JO7W…Using Smartsheet275Mary_A
-
Answered Barbara Silva 39 views 12 comments 0 points Most recent by Barbara Silva Formulas and FunctionsFirst post 02/06/20,Last post 02/17/20I have developed a project schedule that is detailed and has information that should not be shared with the client. In order to provide the client with a summary view, I am using a checkbox column to mark the rows that should be client fac…Formulas and Functions3912Barbara Silva
-
Developing existing formulaAnsweredFirst post 02/17/20,Last post 02/17/20Hi, I have a formula set up to basically check if an action is open. Currently the formula is as follows: =IF(OR([Post AFC Change Status]7 = "1. Received", [Post AFC Change Status]7 = "7. Withdrawn", [Post AFC Change S…Formulas and Functions153sahilhq
-
Answered Sue Crawford (admin) 10 views 1 comment 0 points Most recent by Josh Strong Formulas and FunctionsFirst post 02/17/20,Last post 02/17/20My =IF([email protected]="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combin…Formulas and Functions101Sue Crawford (admin)
-
First post 02/14/20,Last post 02/17/20My Google Sheet shows up in my dashboard with no issue but when I try to save as a PDF and or print the section with my web content widget is blank. How do I get the Web Content in my Dashboard to print or save as a PDF?Using Smartsheet112Rebecca Flores
-
VLOOKUP? INDEX MATCH?AnsweredFirst post 02/13/20,Last post 02/17/20Help please! I'm looking for the invoice amounts from one sheet transfer into another sheet based on a matching CAR#. For example: if CAR# FP2020-1 is listed in spreadsheet (B) then I want the invoice amount associated to populate into t…Formulas and Functions172@SPark
-
Answered Shawn Borror 26 views 3 comments 0 points Most recent by Shawn Borror Formulas and FunctionsFirst post 02/13/20,Last post 02/17/20I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of cont…Formulas and Functions263Shawn Borror -
Answered Christine Rosenberg 22 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/07/20,Last post 02/17/20We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay for 3 item Y, 0 item X and in March …Using Smartsheet223Christine Rosenberg
-
Why Can't I Check a Checkbox in a report?Accepted AnswerAccepted Answer kirsten112286 29 views 6 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/11/20,Last post 02/17/20I haven't had issues with this in the past, it suddenly is no longer working. So weird. I have a report that has 4 columns that can be checked / unchecked. Today, 2 of the columns are allowing me to check/ uncheck while in the report, (w…Using Smartsheet296kirsten112286
-
IF OR AND StatementAnsweredFirst post 02/14/20,Last post 02/17/20I am trying to return color symbols for in a sheet. End goal Date Null, Completed Null, or Past DATE(2020, 3, 31) = "Red" Date is Not "Yes" and Not Past DATE(2020, 3, 31) = "Yellow" Else = "Green" …Formulas and Functions121David Leon
-
Answered Mark Suckling 15 views 4 comments 0 points Most recent by Richard Rymill SBP Using SmartsheetFirst post 02/14/20,Last post 02/17/20We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were marked 100% complete they would no longer …Using Smartsheet154Mark Suckling
-
First post 02/13/20,Last post 02/17/20Is there a way to roll up health of tasks underneath the parent to reflect an "average" health, if you will? I have a formula for my children to render health, however, I can't seem to roll up to the parent. Would the same formu…Using Smartsheet132Lauren T
-
Average children with IFUnansweredQuestion Netanel yosef 13 views 1 comment 0 points Most recent by Netanel yosef Formulas and FunctionsFirst post 02/17/20,Last post 02/17/20hi, i have sheet with ~300 parent row and ~1200 children row. i try to sum the progress in parent row with IF on his children. for example : if one of the children row is "sent to fabrication" he get 100% and i have five children…Formulas and Functions131Netanel yosef
-
why when I remove a person at a sheet level is their permissions removed from the workspace level?Accepted AnswerAccepted Answer Dale Heincelman 30 views 4 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 02/06/20,Last post 02/17/20My co-worker are both admins at the workspace level (which allows access to all of the workspace). How can I remove my co-worker just at the sheet level to avoid aerts to every one shared to the sheet ? When I removed my co-worker at the s…Using Smartsheet304Dale Heincelman
-
Answered Drew Frazelle 14 views 3 comments 1 point Most recent by Drew Frazelle Formulas and FunctionsFirst post 02/14/20,Last post 02/16/20I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is,…Formulas and Functions143Drew Frazelle
-
Trouble with RGYB and blank datesAccepted AnswerAccepted Answer Fletcher Boll 34 views 10 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/06/20,Last post 02/16/20https://us.v-cdn.net/6031209/uploads/569/FNU2H3JBHHNH.png https://us.v-cdn.net/6031209/uploads/118/Q407I4WJTOT1.png https://us.v-cdn.net/6031209/uploads/234/1J6U78YPSH0A.png Hello! I am working with a Health column that refers to our Stat…Formulas and Functions3410Fletcher Boll
-
Answered Mary_A 14 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 02/07/20,Last post 02/16/20Can anyone tell me if the Docusign Integration is Bidrectional or not? Use Case Present users with a Docusign form which ask them to read a waiver and enter three pieces of information: Name Email Event identifier And then sign the form.…Premium Apps and Integrations143Mary_A
-
How do I return the name of the month in one cell if I only have a date (xx/xx/xx) in another cell?AnsweredAnswered Shawn Curwen 12 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/15/20,Last post 02/16/20I'm attempting to track the number of requests received and the months they were requested. What formula can return a Month name for a date (xx/xx/xx) e.g if I have 12/25/19 the formula will return December 2019. Please assist. ThanksFormulas and Functions121Shawn Curwen
-
First post 02/13/20,Last post 02/16/20This happens on 2 of my 10 sheets, and only started happening a few weeks ago. The moment I mouse over the grid of my sheet, the disk save icon immediately goes blue (enabled), thus indicating that something changed on the sheet. Thus wh…Using Smartsheet188Win LeDinh
-
Pulling cell data based on date and nameUnansweredFirst post 02/16/20,Last post 02/16/20Hello, Could someone help me with a bit of a pickle I can't get around? I have a sheet with multiple dates and names and their daily progress. The dates are pre-populated for the entire month with everyone's names assigned for each day. I'…Formulas and Functions160Ryan43
-
First post 02/15/20,Last post 02/15/20Is it possible to publish a calendar link that only displays items form a filtered list isn't of the entire grid?Using Smartsheet81MikeMcKinney -
Answered cyndi_walker108886 11 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 02/15/20,Last post 02/15/20Hello, I'm doing a master summary metrics sheet (in lieu of a summary sheet on the source sheet because I need to build graph charts in a dashboard). I need to count blank cells in a specific column, but only if another column has text. I'…Formulas and Functions112cyndi_walker108886 -
Formula for sum of values in columns of other sheets per collaborator. Cells assigned to "nn".Accepted AnswerAccepted Answer Gerardo_Clarke 14 views 3 comments 0 points Most recent by Gerardo_Clarke Formulas and FunctionsFirst post 02/13/20,Last post 02/14/20https://us.v-cdn.net/6031209/uploads/484/MOKSBC3Z5QGO.png I have a summary sheet "Summary Sales" created from another sheet "ADMIN_2020" in rows 2, 3 and 4 of the "Summary Sales" I have 3 employees assigned. A…Formulas and Functions143Gerardo_Clarke -
Update requests are not being received by team membersAccepted AnswerAccepted Answer Shawn Borror 18 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/10/20,Last post 02/14/20Update requests are not being received by team members who do not have full licenses. Do I need to let help desk know specific servers to whitelist?Using Smartsheet183Shawn Borror
-
Answered Dale Heincelman 13 views 4 comments 0 points Most recent by Dale Heincelman Using SmartsheetFirst post 02/14/20,Last post 02/14/20I believe there was a side effect to a mistake I did. Our structure is one workspace for all of our projects, with each project in a separate folder. I mistakenly removed sharing of my coworkers at the sheet level that were shared at the w…Using Smartsheet134Dale Heincelman
-
Topic: Move Record Issue: Downstream Receiving Table Column Formulas will not stick on incom. recrdAnsweredAnswered Michael Gerdes 21 views 4 comments 0 points Most recent by Michael Gerdes Formulas and FunctionsFirst post 02/12/20,Last post 02/14/20Hi Team, I have move record functionality in my tables, and for some reason, the incoming records coming into my tables will not inherit the formulas on the columns... even when I have two template records hidden on each sheet which I need…Formulas and Functions214Michael Gerdes -
Answered zooom_for_RBX 34 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/28/20,Last post 02/14/20Is there a way how to save or export a formular, so that i can reimport the (excel) file for an oncomming use?Formulas and Functions347zooom_for_RBX -
Answered Christina Denson 17 views 1 comment 0 points Most recent by Richard Rymill SBP Using SmartsheetFirst post 02/13/20,Last post 02/14/20While using the Employee Directory template embedded in a website, is there a way for this information to be displayed in a way other than forcing a user to scroll through an entire list? For example, is a user able to type in a name and …Using Smartsheet171Christina Denson
-
Smartsheet formsAccepted AnswerFirst post 02/14/20,Last post 02/14/20Hi, On a daily basis I fill a Smartsheet form, i.e. load 10+ entries at a time. Is there a way to raise several entries using the form in a batch, to save keep repeating the same standard information (name, email, etc.)?Using Smartsheet187sahilhq
