Sheets

Discussion List

  • Lock or Store Date/Value Solution without using Zapier
    In Best Practice
    Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another shee…
    2953 26
    3K views 26 comments Most recent by Andrée Starå Best Practice
  • UPPER formulas
    In Formulas and Functions
    Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
    187 3
    187 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Daily Update Solution without the need to open the sheet, use Zapier, or similar
    In Best Practice
    Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called hel…
    314 7
    314 views 7 comments Most recent by Paul Newcome Best Practice
  • Data storage EU
    In Using Smartsheet
    Hello! I'm afraid my question is not a new one, but I'm not giving up hope that Smartsheet is interested in expanding into Europe. Since I realized, that EU-GDPR seems to be accepted, the IT-data-security-departments at my Clients in Ger…
    254 2
    254 views 2 comments Most recent by Joachim Mund Using Smartsheet
  • Link to Dashboard on Sheets
    In Using Smartsheet
    Hello! I'm trying to figure out if there is a way to have a column on a sheet populate a link to a dashboard if the primary column is not blank. I know how to insert a hyperlink to the Smartsheet Dashboard, but it appears that cannot be c…
    Answered - Pending Review
    33 1
    Answered - Pending Review 33 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Create Chart Widget Using a Report (not a Sheet)
    In Using Smartsheet
    With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget). I collect weekly "submission date" data from 40+ people. I have created a report that shows when the sub…
    1726 10
    1.7K views 10 comments Most recent by Genevieve P. Using Smartsheet
  • Sheet Formula_ Heath symbol
    In Formulas and Functions
    Hello everyone, I know I am close, but looking for some help. I am trying to create a formula to calculate If start date is less than today, health symbol is Green If start (maybe should be end date) is within (xx) days, health symbol tu…
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Jermaine Johnson Formulas and Functions
  • Barcode Scanner Issue
    In Using Smartsheet
    I have been trying to get the Barcode Scanning to work for our inventory spreadsheet.  I have the latest version of the Smartsheet on my iOS phone which is Version 5.1.  Everytime I try to scan a bar code it just comes up with the number o…
    65 3
    65 views 3 comments Most recent by A. Aron Using Smartsheet
  • Conditional Formatting in a Report
    In Using Smartsheet
    Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
    2359 9
    2.4K views 9 comments Most recent by Andrew Stills Using Smartsheet
  • One Approval for Multiple Lines/Whole Sheet
    In Using Smartsheet
    Hi everyone, I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column th…
    Accepted
    22 2
    Accepted Answer 22 views 2 comments Most recent by Lila De Vera Using Smartsheet