functionality

Discussion List

  • Transferring ownership
    In Using Smartsheet
    Hello! I am an admin at workspace of the company. I can't take ownership of sheets from an existing user with business license. I have this message when trying to get ownership: You cannot take ownership of this item because the current us…
    Answered - Pending Review
    196 8
    Answered - Pending Review 196 views 8 comments Most recent by Andrée Starå Using Smartsheet
  • Nested IF with CONTAINS
    In Formulas and Functions
    Hello, can anyone help me why this formula doesn't work? =IF(CONTAINS("Red",Issue1),"Red"),IF(CONTAINS("Green",Issue1),"Green"),IF(CONTAINS("Yellow",Issue1),"Yellow",)
    Answered - Pending Review
    453 1
    Answered - Pending Review 453 views 1 comment Most recent by PeterR Formulas and Functions
  • Can you create a master project plan with rollup plans below?
    In Using Smartsheet
    I need to create multiple project plans with one resource in common so I want to make tasks between the plans dependent on eachother so that the engineer doesn't have overlapping work and if one task is delayed it will impact the other pro…
    Accepted
    421 4
    Accepted Answer 421 views 4 comments Most recent by Claire Rigby Using Smartsheet
  • Web Form not populating data on sheet
    In Using Smartsheet
    I have created a web form that populates the data onto a sheet. Its similar to a web form and sheet I have already created. I have tested with a few users and the data comes through fine. 2 other users have submitted a web form but the inf…
    Answered - Pending Review
    105 2
    Answered - Pending Review 105 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Workspace "cover page"
    In Using Smartsheet
    Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact w…
    Answered - Pending Review
    140 4
    Answered - Pending Review 140 views 4 comments Most recent by Paul Newcome Using Smartsheet
  • Help to Simplify Logic
    In Using Smartsheet
    I'm creating a smartsheet with several columns and created a few formulas that I believe could be simplified to achieve the same result, but I can't seem to think of an easier way. Can you please try to help me out? HEALTH COLUMN =IF(OR(CO…
    Answered - Pending Review
    73 6
    Answered - Pending Review 73 views 6 comments Most recent by Paul Newcome Using Smartsheet
  • I have some questions about using smartsheet for managing sign ups for courses
    In Formulas and Functions
    The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email …
    EEE Profile Photo EEE
    Answered - Pending Review
    31 2
    Answered - Pending Review 31 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Build questions in a form based on rows, not columns
    In Using Smartsheet
    Is this possible? I have a checklist sheet, with multiple questions set out in each row. Id rather avoid making each question a column so would it be possible to create a form based on the questions in the first column for each row? Thanks…
    Accepted
    249 5
    Accepted Answer 249 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Can you create a Sheet Rollup of all open actions from each project owners sheets?
    In Using Smartsheet
    What about a sheet to roll up all open tasks of each project owners sheets so a managed worked flow to request updates would include all updates needed for all the project owners sheet actions? This way they are not getting a lot of separa…
    Answered - Pending Review
    44 9
    Answered - Pending Review 44 views 9 comments Most recent by Andrée Starå Using Smartsheet
  • How to create formula to count over the past seven days
    In Formulas and Functions
    Hello, I'm trying to count the number of projects delivered in the past seven days. This is what I have so far: =COUNTIFS(Status:Status; "Delivered";Delivery Date:Delivery Date; >=TODAY(-7)) I'm not sure what's going wrong or…
    Answered - Pending Review
    106 1
    Answered - Pending Review 106 views 1 comment Most recent by Andrée Starå Formulas and Functions