Wholesale Distribution

Discussion List

  • Email User Completed Form
    In Using Smartsheet
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    Accepted
    198 3
    Accepted Answer 198 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Locking or freezing the TODAY() formula
    In Formulas and Functions
    Good day all, I've looked around in the community about locking or freezing a current date, but I'm still having issues. My goal is to lock a start date that's triggered by entering a X and have that current date freeze until the x is remo…
    1271 5
    1.3K views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Is There Really No Built-in Log\NL Function?
    In Archived 2017 Posts
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    222 2
    Closed 222 views 2 comments Most recent by Ford Archived 2017 Posts
  • Update field in another sheet
    In Using Smartsheet
    Hi there, i'm trying to figure this out: I have sheet #1 with an email address field. When that field is updated, Smartsheet automatically updates sheet #2 email address field with the email entered in sheet #1. Is this possible?
    1079 3
    1.1K views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Sheet automation with a mix of relative dates and date ranges
    In Using Smartsheet
    Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc.  Key notification criteria is based on start and/or end dates. Currently, their notification is setup to …
    167 3
    167 views 3 comments Most recent by wboyle111121 Using Smartsheet
  • Project Approval Received / Master Project Sheet Populated
    In Formulas and Functions
    I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be cop…
    112 1
    112 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Is it possible to apply Conditional Formatting with a formula?
    In Formulas and Functions
    In Excel we have the ability to use custom formula for conditional formatting, is this possible in SS? Please see screenshot below.   I need to compare column values to the value at the top cell.  I can do this by adding more columns and…
    53 1
    53 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Card View Conversations
    In Using Smartsheet
    What am i missing, Card view is a superb feature of SS and starting to use lots, however when you add a task or subtask there is not an option to start a conversation, you have to go back to grid view for this.   further more where there…
    UWG Profile Photo UWG
    43 2
    43 views 2 comments Most recent by Alejandra Using Smartsheet
  • Card view sub tasks, can't see sub tasks of sub tasks
    In Using Smartsheet
    Card view is excellent, so good, was about to run my whole company of it!, however I have hit a snag –   In card view you can view level one and its subtasks – good, however I now cannot see the subtask of a subtask, you cannot even see…
    UWG Profile Photo UWG
    54 1
    54 views 1 comment Most recent by Alejandra Using Smartsheet
  • Add attachment to multiple sheets and respond?
    In Using Smartsheet
    I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert…
    36 1
    36 views 1 comment Most recent by Andrée Starå Using Smartsheet