Discussion List

  • How to Back-up Sheets?
    In Using Smartsheet
    Is there is a backup in the cloud of our sheets? Do you have any recommendations to prevent loss of data should something happen? Should we be saving a back up daily or regularly?
    206 4
    Accepted Answer 206 views 4 comments Most recent by Bee Ng Using Smartsheet
  • Conversations in Reports
    In Using Smartsheet
    I currently use reports tied to a central tracker to report out project updates to several different teams. Some of these projects require sharing of attachments and conversations about those attachments using the row's conversation tool. …
    347 4
    347 views 4 comments Most recent by David Lane Using Smartsheet
  • COUNTIFS with NOT CONTAINS from a Referenced sheet with two columns selected
    In Formulas and Functions
    Hello! I've searched through a few community posts but cannot seem to find an answer to my formula I'm trying to calculate how many products we have in one column that are not "done" from another column that are both being refere…
    21 5
    Accepted Answer 21 views 5 comments Most recent by Ramzi K Formulas and Functions
  • Would Report have the ability to filter columns as per new features announced in ENGAGE 2020?
    In Using Smartsheet
    Hi All, I created a report using report builder that consolidates data from different project plans at the lower level with a set criteria. I am trying to see if there is a way to filter KPI within the report. As I am aware that Smartsheet…
    Answered - Pending Review
    41 2
    Answered - Pending Review 41 views 2 comments Most recent by Hardik Sharma Using Smartsheet
  • Pinpoint locations to a map
    In Using Smartsheet
    Is there any way to extract an address from a sheet and pin it to a map?  I would want to pin several locations to the same map if possible. I was thinking maybe somehow do this in a dashboard??   Thank you, Cheryl
    987 9
    987 views 9 comments Most recent by Timothy Bugno Using Smartsheet
  • Relational Database?
    In Formulas and Functions
    Hello All, We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
    2077 4
    2.1K views 4 comments Most recent by netizenden Formulas and Functions
  • Calculating Duration based on Effort and Resource Allocation %
    In Using Smartsheet
    Why has product development ignored the need of real project managers to be able to calculate durations based on task effort and resource allocation percentages? This is one of the most basic needs of a project management tool and SS's res…
    134 1
    134 views 1 comment Most recent by Anne Lewson Using Smartsheet
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    115 3
    115 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Date and Balance Formula
    In Formulas and Functions
    Hi there, I need help creating 2 formulas I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately. The second formula would essentially be t…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Ileana Stover Formulas and Functions
  • Copy and Paste Error
    In Using Smartsheet
    Hello Experts, My Sheet is having 10300+ rows. I am trying to delete entire rows and performing a copy and Paste. After attempting to copy and Paste 1st 500 Items and tried to SAVE. I am getting this error. Its forcing me to log out but wh…
    79 2
    Accepted Answer 79 views 2 comments Most recent by Sandra Guzman Using Smartsheet