Join the Smartsheet Community
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
Join the new group for Bridge by Smartsheet!In Premium Apps and IntegrationsWe've launched a new group for Bridge 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 your questions about building workflo… -
Lookup formula instead of valueIn Formulas and FunctionsI am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?
-
Calendar App- Multiple date displayIn Premium Apps and IntegrationsHi there, I've been searching the learning center but can't find my answer. Our projects track events by EITHER a start/end date OR Due Date/Activation Date. Is there a way to display BOTH dates on the calendar app? The settings …Answered - Pending Review 53 views 2 comments 0 points Most recent by Ross Novotny Premium Apps and Integrations
-
Roll up not working as expectedIn Using SmartsheetI have a project with several tasks that are children of a parent task. The roll-up of the Work and Duration fields of the parent item are not working as expected. For some parent tasks, the roll-up seems fine, but I have other parents who…
-
Formulas and functions in formsIn Formulas and FunctionsHi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…Answered - Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Formula WoesIn Formulas and FunctionsMy old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
-
Accessing form fields in form submission URLIn Premium Apps and IntegrationsIs it possible to access form field values to pass them as a query string in the form submission URL Example below; (Image)Answered - Pending Review 6 views 1 comment 0 points Most recent by Andrée Starå Premium Apps and Integrations
-
Inbound cell link loses timestamp info and only shows dateIn Using SmartsheetHello! I am trying to capture times clocked in and out by a team. I created 2 input sheets, one that captures time in via a system timestamp of last modified, and another to capture the timestamp for when one clocks out. I am then pulli…
-
COUNTIFS + FIND QuestionIn Formulas and FunctionsHi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the…Answered - Pending Review 10 views 3 comments 0 points Most recent by David Tutwiler Formulas and Functions
-
Checkbox formula with percentageIn Formulas and FunctionsSmartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
-
Referencing a sheetIn Formulas and FunctionsHi! I'm wondering if there is any way to reference a full sheet. If you are able to do that and then write formulas that include columns within that referenced sheet, will that work? Thanks!Answered - Pending Review 5 views 2 comments 0 points Most recent by clairee42221 Formulas and Functions
