Using Smartsheet

Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.

Discussion List

  • Can someone please help how this formula can work with the similar text?
    In Using Smartsheet
    =IF(OR(CONTAINS("Work", [ID]@row)), "Right" , IF(OR( CONTAINS("Worklife", [ID]@row)), "Wrong",""))
    Answered - Pending Review
    20 4
    Answered - Pending Review 20 views 4 comments Most recent by Aatish Chaudhary
  • Card View Labels
    In Using Smartsheet
    Is there a way to show a field or custom value in the label of card view? For example, I have lanes based on assigned to->all good here and easy to do. What I want in addition is next to that name display # of hours assigned to that per…
    Unanswered
    10 0
    Question 10 views 0 comments Started by Bill C.
  • User tried to add sheet owner as a Contact in a multi-select contact field, removes other contacts
    In Using Smartsheet
    I created a form/sheet that has the entire team as dropdowns in a contact field. When a user tries to add my name, it removes all other contacts from the multi-select field. Why is this and is there a fix?
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Genevieve P.
  • How can I ban or control indenting and outdenting?
    In Using Smartsheet
    How can I stop users making a mess with indenting and outdenting? I am providing users with a template which contains some summary rows. I have formulae on these rows. They are: Level 0 - totals Level 1 - subtotals for tasks within that g…
    Unanswered
    9 0
    Question 9 views 0 comments Started by CycleBagEd
  • Receive an emailed attachment on submission of form.
    In Using Smartsheet
    Im creating a shipping request sheet and have created a form so people can submit address details etc . Once submitted this will go to a department for approval. I would also like an attachment to be sent with the email . For example, the …
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå
  • How can I make a pie chart that aggregates dropdown choices in a column?
    In Using Smartsheet
    I have survey results that I need to make into a chart - for example, let's say for a question where they rate something from 1-5. Ideally, in a pie chart, it would show that x% of respondents answered 4, x% of respondents answered 5, etc…
    Accepted
    13 2
    Accepted Answer 13 views 2 comments Most recent by JessW
  • Reminder: Request to join Smartsheet Account
    In Using Smartsheet
    Hi, I am the system admin of smartsheet in my organisation, using business plan account. I have invited some of my colleague as free collaborators to view the sheet. The free users know they only need to view and never request for licens…
    Answered - Pending Review
    28 3
    Answered - Pending Review 28 views 3 comments Most recent by YM Chan
  • How do I create an assignments summary sheet?
    In Using Smartsheet
    I'm working with a healthcare department, and our staff are assigned cases to contact trace. They contact the individual or facility, enter in the relevant info to a master sheet, take whatever notes they need, and then mark it as complete…
    Accepted
    22 4
    Accepted Answer 22 views 4 comments Most recent by Andrée Starå
  • Issues with TODAY formula
    In Using Smartsheet
    I'm using this formula (=COUNTIFS({FINAL - Post Check Tracker Range 24}, "Outstanding", {Post Check) to count entries completed today from another sheet. The formula is pulling information from the automated "Created" c…
    Answered - Pending Review
    26 5
    Answered - Pending Review 26 views 5 comments Most recent by Kelly Moore
  • Combine Info from Multiple Projects to a Report, pull status from Report to Sumamry Sheet
    In Using Smartsheet
    First, forgive me if this is convoluted, I may be approaching this in entirely the wrong manner. I have a varying number of workspaces, one workspace for each project. The number of projects changes over time. I currently provide a "…
    Unanswered
    21 0
    Question 21 views 0 comments Started by mattstoc