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

  • Import Excel file and include embedded images
    In Using Smartsheet
    Hi,  I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something?   Or do I have to re-import those images manually,…
    111 3
    111 views 3 comments Most recent by slaflen17131 Using Smartsheet
  • automated update requests for multiple rows
    In Using Smartsheet
    I am looking for how to send multiple rows in the same automated update request. We need to confirm contact information for building proctors. 1 person might be the proctor for 10 buildings. I do not want to send this person 10 separate…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Anna Barwick Using Smartsheet
  • System "Modified Date"
    In Formulas and Functions
    I have a column in my sheet that is the system Modified (Date) date and time. I need to know the latest date and time in that column because sometimes the date is the same but the time is different. MAX only works with the date part. Ca…
    Answered - Pending Review
    35 3
    Answered - Pending Review 35 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Calendar App - Users unable to create new events
    In Premium Apps and Integrations
    Hi there, I created a shared calendar for my team using the Calendar App and for some reason, my team is unable to create new events. I've tried the following - Ensured "allow new event" is checked in the advanced settings of the…
    Unanswered
    15 0
    Question 15 views 0 comments Started by Benjamin Brunnette Premium Apps and Integrations
  • Multiplying column values?
    In Formulas and Functions
    Hi Community, I have a sheet with section score values ("Ease Score", "Permanence Score", "Impact Score", "Cost Score") that I am trying to multiply to find an overall score ("Project Score&qu…
    Accepted
    8 5
    Accepted Answer 8 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Linking Children to Parents
    In Using Smartsheet
    I need to use SmartSheet as a data collection tool. The user will have a sheet with Company information including a unique Company ID. I need a way for them to enter Contacts tied to the Companies by the Company ID I thought about using F…
    Answered - Pending Review
    28 9
    Answered - Pending Review 28 views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Hide Rows from Viewers or Report
    In Formulas and Functions
    Hi I have a project that I have created. I want to share the plan with a client but our template has the financials of the project in it. Obviously I do not want them to see this. Is there a way that I can hide certain rows from a viewer…
    Accepted
    16 6
    Accepted Answer 16 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Project Health Formula to Auto Populate a Symbol
    In Formulas and Functions
    Hi I have a formula that flags the health of each row (task) via a RAG status. Green is healthy, Amber is at risk or in progress and Red is a failure. This is set up to work off the start date and % complete. However, it just isn't right. …
    Answered - Pending Review
    18 6
    Answered - Pending Review 18 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Help with Formula - Look a value in a cell and if it is 1 of 4 values fill in a different cell
    In Formulas and Functions
    I'm importing data from a legacy excel sheet and the priority is designated with a 1-4 with a critical to low. I want to check that column and if it is one of the values it puts an update severity in a different column. Since the new sever…
    Accepted
    14 9
    Accepted Answer 14 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • New Format Reversal Date
    In Using Smartsheet
    This is not something you can generic response your way out of. Do not tell me to "submit an enhancement request" while you sweep this colossal failure under the rug. Answer the question. Will Smartsheet allow users to adjust the…
    Accepted
    32 0
    Accepted Answer 32 views 0 comments Started by Miles Allison Using Smartsheet