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

  • Index & Match formula
    In Formulas and Functions
    Hi Smarties, I have a question on Index and Match formula. I am using the Project Management Office template set from Smartsheet. Based on the Intake sheet, a new project is created, and a number will be auto-assigned (SM-004) I made a …
    Accepted
    17 1
    Accepted Answer 17 views 1 comment Most recent by Syed Muhafzal Formulas and Functions
  • Approval workflow
    In Using Smartsheet
    Hello! I need to create an approval workflow with these conditions. Please also find below the problems I'm encountering: When a row is added, changed, or deleted. (Problem #1: I don't manage to set this up for rows that have been deleted.…
    Answered - Pending Review
    40 9
    Answered - Pending Review 40 views 9 comments Most recent by Berta Using Smartsheet
  • Moved: Column order in charts
    In Formulas and Functions
    This discussion has been moved.
    1 0
    Closed 1 view 0 comments Started by Genevieve P. Formulas and Functions
  • Can a child row be auto-created when a row column status changes?
    In Using Smartsheet
    Hi, When a row status column status changes from pending to suspend, can a duplicate row be created as a child row, and when the child row status changes from suspend to unsuspend, can another duplicate row be created as another child row…
    Accepted
    34 3
    Accepted Answer 34 views 3 comments Most recent by AFlint Using Smartsheet
  • How to count number of Past Due Tasks
    In Formulas and Functions
    I use the formula below to track my past due tasks : but it is not giving me the correct number currently my sheet does not have any late task according to my filter below : Which formula should I use to make it possible ?
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • PMO Template: New project not linking to the Project Intake Sheet
    In Using Smartsheet
    Hey Everyone, Hoping you can help, I am using the PMO template. I am on the 4 step where I need to copy the project ID. However when I go to the project intake form to get it, the Project ID is not listed and the sheet is not recognizing…
    Answered - Pending Review
    4 1
    Answered - Pending Review 4 views 1 comment Most recent by Ayelet Weiner Using Smartsheet
  • How to Track Someone's Past due Task
    In Formulas and Functions
    Hi, I have tried to write down a formula at the sheet summary that tracks the number of past due tasks assigned to a specific person on my sheet but it is giving a #UNPARSEABLE error below is how I have done it : =COUNTIFS([Is Past Due?]:[…
    Accepted
    14 9
    Accepted Answer 14 views 9 comments Most recent by Andrée Starå Formulas and Functions
  • How do I freeze columns in a report on a dashboard?
    In Using Smartsheet
    I'm trying to include a report on a dashboard, but I can't seem to figure out a way to freeze columns when the report is on the dashboard. Is there a way to do this? Any suggestions are greatly appreciated.
    423 8
    423 views 8 comments Most recent by Kegan Copas Using Smartsheet
  • 10,000ft Rebranded to Resource Management by Smartsheet
    In Product Announcements
    In 2019, Smartsheet acquired 10,000ft to build on our vision of empowering everyone to manage projects, automate workflows, and rapidly build solutions at scale. Last year, we launched an integration between Smartsheet and 10,000ft to impr…
    90 0
    90 views 0 comments Started by Adam Lang Product Announcements
  • Final Approval
    In Using Smartsheet
    I have an approval workflow that works great, but I'd like to make a certain approver the final vote. Right now, approvals are sent to the entire CAB, and responses are entered into each approvers specific column with traditional Submitted…
    Accepted
    2 2
    Accepted Answer 2 views 2 comments Most recent by Shannon5150 Using Smartsheet