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

  • Sync a column change in multiple reports
    In Using Smartsheet
    I dont think Ive seen answer to this, but I have multiple reports in the same format that are used to separate different sales reps (not internal so current user wouldn't help). If I need to add a column to all the reports I have to do it …
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Column formula edit
    In Formulas and Functions
    I was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thank…
    Accepted
    10 5
    Accepted Answer 10 views 5 comments Most recent by Deborah Stoneman Formulas and Functions
  • Change the "from" email address on automated emails
    In Using Smartsheet
    As the admin on my account, any time an automation sends an email the recipient sees the following: FIRSTNAME LASTNAME via Smartsheet <[email protected]> I do not want my name on these automation emails, is there a way t…
    Unanswered
    10 0
    Question 10 views 0 comments Started by Ryan Rubens Using Smartsheet
  • Conditional Logic in Forms
    In Formulas and Functions
    Hi @Andrée Starå I was trying to replicate your two-form solution, however I could not access the back end. I am trying to create a Parent / Children in the sheet where in the user could provide # of lines when " Total value of order…
    Unanswered
    11 0
    Question 11 views 0 comments Started by Archie Villa Formulas and Functions
  • Automation - Alerts for External Users
    In Using Smartsheet
    Hi there, I am having trouble with the automation in Smartsheet, specifically around alerting external users. The automation is for an issue control sheet, with automation that if "status" = resolved, alert user who logged (via f…
    Answered - Pending Review
    5 4
    Answered - Pending Review 5 views 4 comments Most recent by James Adderley Using Smartsheet
  • Expandable CRM
    In Premium Apps and Integrations
    Has anyone integrated Expandable CRM with Smartsheet? Any lessons learned?
    Answered - Pending Review
    5 1
    Answered - Pending Review 5 views 1 comment Most recent by Ben G Premium Apps and Integrations
  • Dependency based on prior line item with auto change when sorting?
    In Using Smartsheet
    Hello! New user to Smartsheet here; was wondering if there is a way to make tasks change dependency automatically as they are moved in the sheet. Specifically, I manage team where all members can close similar action items, and I have a qu…
    Unanswered
    9 0
    Question 9 views 0 comments Started by Sean Wright Using Smartsheet
  • Column Formula not selectable as Gantt Label
    In Formulas and Functions
    Hi Folks, Is this a bug? For Gantt chart labels, I use a column that concatenates and formats the task and end dates; call this column "Gantt Label". I select this as my Gantt label and it looks great. To prevent my formula from …
    Accepted
    15 3
    Accepted Answer 15 views 3 comments Most recent by Ben G Formulas and Functions
  • URL Query string did not move with "Save as New" How to remedy?
    In Formulas and Functions
    I used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query stri…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by Ben G Formulas and Functions
  • What criteria use to determine a "current user".
    In Formulas and Functions
    I have a report that surfaces information based on a current user filter. It is filtered on a contact column. The issue is, my users are all over the map with logon ids. We have two sets of emails in my company, internal and external. T…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by David Dolch Formulas and Functions