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

  • Formulas for % Allocation in Resource Manager
    In Using Smartsheet
    Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column? I've done quite a bit of research on …
    Accepted
    1 4
    Accepted Answer 1 view 4 comments Most recent by Deanna Bowman Using Smartsheet
  • Greyed out Baseline Functionality
    In Formulas and Functions
    I have an issue with greyed out Baseline Functionality and I pay for a TEAM Plan which I think is better than an Individual Plan but lower than Enterprise or Premier. How come I can't s access the Baseline feature even when I am owner of t…
    Unanswered
    3 0
    Question 3 views 0 comments Started by Charles Fombrun Formulas and Functions
  • Notification Email: Send to Contacts in a Cell
    In Using Smartsheet
    The below form was built that when it is approved you will have 3 email alert notifications (i.e. 1. facility lead contact email, 2. HR contact email and then a set of 3. recipients). Would you be able to show me how I can use the HR conta…
    Accepted
    23 2
    Accepted Answer 23 views 2 comments Most recent by Krissia Using Smartsheet
  • Greyed out baseline tab
    In Formulas and Functions
    Hi, I'm trying to make use of the Baseline function, but it's greyed out. I'm in the Gannt View and also the owner of the sheet.
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Charles Fombrun Formulas and Functions
  • Form Fields Out of Order
    In Formulas and Functions
    I have created a form with with about 30 fields. I have set up some automated update requests. When the person receiving the update request link opens up the link to the form, all the fields are not in the order I set them up in. Any ideas…
    Accepted
    1 3
    Accepted Answer 1 view 3 comments Most recent by Andrée Starå Formulas and Functions
  • Any formula, if duplicate, say: "Duplicate"?
    In Formulas and Functions
    Any formula, if there's a duplicate in this column, say: "Duplicate"? Thank you!
    Accepted
    21 25
    Accepted Answer 21 views 25 comments Most recent by Paul Newcome Formulas and Functions
  • Using decision symbols: Yes, No & Hold
    In Formulas and Functions
    Hi all, Understand that this has probably been answered before however I can't quite find the solution I need and have spent a little too long trying to get this sorted. I need to display Yes, No or Hold symbols with the following paramet…
    Accepted
    11 6
    Accepted Answer 11 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • COUNTIFS using Dates and IFERROR
    In Formulas and Functions
    I'm trying to replace some formulas in a summary sheet that I accidentally wiped but I cant seem to get them to work and I know I'm missing something but I'm not sure what. What I'm trying to count is all the dates listed in the year 2020 …
    Accepted
    21 7
    Accepted Answer 21 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • IF Function Question - Symbol changes with date
    In Formulas and Functions
    Hello, I have been having some issues configuring a formula in smartsheets. I am trying to write a function where the Symbol (Green, Yellow, Red, Grey Balls) in the 'Status' column adjusts according to date in the 'Start' column. Green a…
    Accepted
    61 8
    Accepted Answer 61 views 8 comments Most recent by Paul Newcome Formulas and Functions
  • Gantt chart - date fields ok from formulas?
    In Using Smartsheet
    Hi, all. I have data in table where two date columns are derived from formulas. When I try to use the Gantt chart functionality it says that my grid needs at least two dates columns and doesn't allow me to continue. I have two date columns…
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Paul Newcome Using Smartsheet