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

  • Report showing parent task?
    In Using Smartsheet
    Hello, I would like to get a report showing the parent tasks. Is it possible? Thank you
    Answered
    7 1
    Answered 7 views 1 comment Most recent by Annie R. Using Smartsheet
  • Net duration between 2 dates AND hours
    In Formulas and Functions
    Hi, I use this formula to calculate duration in minutes between two dates and time (see picture attached). Goal is to time delay of response between reception of email and answering email but to exclude hours people are not working. Here i…
    Answered
    14 12
    Answered 14 views 12 comments Most recent by Julie Barbeau Formulas and Functions
  • using priority with Today function
    In Formulas and Functions
    I am trying to use priority symbols for two separate date columns to report "high for 60 days out, "Medium for 180 days out, and "Low" for everything else based off the two columns: Landlord Notice Date and Expiration D…
    Answered
    6 2
    Answered 6 views 2 comments Most recent by Kristen Roberson Formulas and Functions
  • SUMIF Help
    In Formulas and Functions
    Hello! I am trying to come with a total number based on region and type of project. For example, the project type is new product, the region is APAC and the 1yr rev is $1M. I need a metric where the formula captures the same region, the …
    Answered
    6 1
    Answered 6 views 1 comment Most recent by Devin Lee Formulas and Functions
  • 2 variable function in a formula
    In Formulas and Functions
    Hello! I have 2 variables that determine what the returning value is. First variable would be Name (row), second variable would be Score (column header). The Score value in the formula is a variable and is determined by data entry. For i…
    Answered
    14 2
    Answered 14 views 2 comments Most recent by ZennerJ Formulas and Functions
  • Alerts only partially working
    In Using Smartsheet
    This is a slight variation on the "Alerts not working" or "Alerts stopped working" questions that pop up frequently. In my case, the alerts stopped working and I finally figured out that if I created an alert *that did …
    Answered
    14 4
    Answered 14 views 4 comments Most recent by Tracy Petrie Using Smartsheet
  • Error Code on multiple scripts - PLEASE HELP - URGENT
    In API & Developers
    Request failed for https://api.smartsheet.com returned code 400. Truncated server response: { "errorCode" : 1012, "message" : "Required object attribute(s) are missing from your request: values.", "refId&…
    Unanswered
    8 0
    Question 8 views 0 comments Started by kashyap.patel API & Developers
  • A way to document the last time a linked sheet was modified?
    In Using Smartsheet
    Hello! I have a master project sheet with other sheets linked to it. I am looking for a way to have the master sheet document the last time each linked sheet is modified. On the attached screenshot, column titled "Project Plan Stage&…
    Unanswered
    7 0
    Question 7 views 0 comments Started by DReyes Using Smartsheet
  • I would like to have my formula simplify. I am not great with adding and/or to my formulas.
    In Formulas and Functions
    =COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY NUMBER]@row, {COLLECT PLANT EXHANGE TEMPLATE ROOM}, [ALL COPY]@row, {COLLECT PLANT EXHANGE TEMPLATE Range 5}, [REF DATE]@row, {COLLECT PLANT EXHANGE TEMPLATE TYPE 1}, [TYPE OF …
    Answered
    26 6
    Answered 26 views 6 comments Most recent by Mary Kam Formulas and Functions
  • Notify someone
    In Using Smartsheet
    Hello, I have a sheet that is updated on a daily basis using the "comment" feature. I have a manager who needs to be able to see the line items that are not updated that week. Since the only field that is being used in the shee…
    Unanswered
    6 0
    Question 6 views 0 comments Started by Melissa Rojas Using Smartsheet