Other
Discussion List
-
Calculating Time in HH:MM:SSIn Formulas and FunctionsHello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more de…
-
Form entry/Copy row automation/Row locationIn Formulas and FunctionsHello all! I am really hoping this is something easy I am just overlooking. The sheet above has a form. When the form is completed the row of information does not populate in the first available row, but a random row typically 25+. The she…
-
Smartsheet University Is Here!In General AnnouncementsHi Community, We are excited to introduce Smartsheet University, a single platform for eLearning, live instructor-led training, in-person training, and custom training. Smartsheet University offers unique learning paths and meaningful con…
-
Notifications to Company Managed Distribution ListsIn Using SmartsheetNow that smartsheet permits emails to outside users my ability to use the sheets has greatly increased! Unfortunately I am running into an issue when trying to send emails to company generated distribution lists. I am not sure if it a secu…
-
Vacation & Time-Off ManagementIn Using SmartsheetHas anyone used smartsheet to manage time-off requests and/or vacation for a pool of staff (approx. 200)?
-
LookUp and Match a value located in a cell with multiple values and return single and/or multiple vaIn Formulas and FunctionsHi, I am hoping someone can help with this formula. I was able to get this working using VLOOKUP when there were fewer complexities. In Sheet 2 when there is a value in the "Lot Number" cell, * The formula should look at Sheet…
-
Dashboard Templates that can be populated with data from rowsIn Using SmartsheetI create individual dashboards each quarter for 15-20 projects then I have to manually link all fields. Is there a way to create a dashboard template that can be linked to the projects that will populate the fields, creating the dashboards…
-
Task Management - Total Count for Section when Adding/Deleting RowsIn Formulas and FunctionsGood morning! How do I track the total count for a section of rows without having to manually update the formula if a row is added or deleted from the section? For example, I have a section with this formula - =COUNTIF([Include in Tot…Answered - Pending Review 36 views 4 comments 0 points Most recent by Kenya Asbill Formulas and Functions
-
Restricting Text/Number Columns to a FormatIn Using SmartsheetHello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful t…
-
How can I count distinct values under a same month?In Formulas and FunctionsHi everyone, I currently have a data set for which I would like to count all unique values that are under a same month and a same year. For example, the following table shows two duplicate values (TR ID's) on two different dates. In this …Answered - Pending Review 162 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
