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

  • Using Smartsheet for Knowledge Management
    In Formulas and Functions
    Does anyone use Smartsheet for Knowledge Management? I'm thinking of utilizing Smartsheet for this purpose ("How To" videos, templates for employees to use, ect). I was wondering if anyone uses if for a similar purpose if you cou…
    Answered - Pending Review
    18 1
    Answered - Pending Review 18 views 1 comment Most recent by Bassam.M Khalil Formulas and Functions
  • Using form for book appointment times
    In Using Smartsheet
    I want to use a form to allow sign up for meeting times. I would need the times available to either disappear after someone has selected it or be marked as unavailable automatically on the form. I thought to try locking the column after it…
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Bassam.M Khalil Using Smartsheet
  • Alert about Community Questions
    In Using Smartsheet
    Hİ there ; is there any option in community about that ; when my question replied a notification will come to my mail that my question answered from someone .
    Accepted
    14 2
    Accepted Answer 14 views 2 comments Most recent by Erhan_79 Using Smartsheet
  • Need to ignore text (NA) in cell referenced in a formula
    In Formulas and Functions
    I have the following formula to determine Status: =IF(OR(TODAY() > [Due Date1]@row, TODAY() > [ Due Date2]@row, TODAY() > [Due Date3]@row, TODAY() > [Due Date4]@row), "Red", "Green") It works as expected whe…
    Answered - Pending Review
    20 1
    Answered - Pending Review 20 views 1 comment Most recent by Bassam.M Khalil Formulas and Functions
  • Workspace vs Folder , difference ?
    In Using Smartsheet
    Good day, what are the main difference between folder directory and workspace directory ? They look like to different directory type with same functions to me and wondering if im missing some advantages for my misunderstanding Thank y…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Bassam.M Khalil Using Smartsheet
  • How to sum up column RGY statuses?
    In Formulas and Functions
    Hi Smartsheeters! I am trying to sum up column RGY statuses. The formula that I use averages the sratus and I end up with either Green or Yellow.  =IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNT…
    Accepted
    16 6
    Accepted Answer 16 views 6 comments Most recent by Carol Rykovanova Formulas and Functions
  • How to edit an existing row through a Smartsheet Form (Not an update request)
    In Using Smartsheet
    We have an automation that pops up a smartsheet form for our sales agents. They speak with customers multple times. We'd like to use the form to edit existing rows (Not create new rows). The Update Request Workflow solution does not work …
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Neil Watson Using Smartsheet
  • Approval Signature
    In Using Smartsheet
    Hi, I use SMARTSHEET because it is intuitive. However I am wondering why there is no way to add an approval signature when approving forms. I do not want to use integrated apps where I have to pay. I see a lot of comments asking how to …
    Unanswered
    10 0
    Question 10 views 0 comments Started by Dan Modglin Using Smartsheet
  • My parent rollup is not working properly
    In Using Smartsheet
    I am new, so feel free to correct me if it appears I am not understanding: My parent row should show the earliest start date from the values in the child rows, but it is blank. And it is editable. I have decreased the indent, saved, incre…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by KDM Using Smartsheet
  • Need to create a column that translates "End Date" Month to Quarter
    In Formulas and Functions
    Trying to create a column that tells me which quarter an item will be ready in the future. I can get the Month of the Date cell easy enough but can't figure out how to do a value range that works. This works =IF(MONTH([End Date]@row) <…
    Accepted
    21 1
    Accepted Answer 21 views 1 comment Most recent by Derek Lohman Formulas and Functions