Discussion List

  • Adding to Inventory
    In Formulas and Functions
    I'm sure this is simple, but I've searched for a while and haven't found anything similar!  I have a sheet set up to track each piece of marketing collateral.  It starts w/ the beginning quantity (say 100 pieces) and deducts the number of…
    89 3
    Answered ✓ 89 views 3 comments Most recent by Paul Newcome Formulas and Functions
    In Formulas and Functions
    HI,   I have a formula  =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE  can anyone help fix this issue?? Please see attached excel with formula in Column D  Thank you …
    260 12
    260 views 12 comments Most recent by Andrée Starå Formulas and Functions
  • Dashboard Widget Chart Issue with Multi Select
    In Formulas and Functions
    I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing somethi…
    650 9
    650 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Method to limit attachment types?
    In Using Smartsheet
    I have a form that is designed for employees to submit news stories for our website to which they are also allowed to upload an image to accompany the story.  My problem is that, despite specific instructions NOT to do so, employees often …
    156 4
    156 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Proofing Review Request
    In Using Smartsheet
    Hello, I am starting to test out the new Proofing functionality and was wondering if there are permission level limitations on who can send out the "Set up Review Request"? We have some people who are admins and some who are not…
    73 4
    73 views 4 comments Most recent by Bradley Durham Using Smartsheet
  • Countifs project status is neither complete nor cancelled
    In Formulas and Functions
    I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…
    325 7
    325 views 7 comments Most recent by Genevieve P. Formulas and Functions
  • How to include double quotes in the output of a text formula
    In Formulas and Functions
    I am trying to combine several text elements into an image attribution for each row on my sheet. Here's my formula: ="American Society for Microbiology " + Category1 + ". " + Title1 + ", " + SubmitterFirstNam…
    637 4
    637 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • Automatic item numbering
    In Archived 2015 Posts
    It would be really good to be able to format text entries so that they are numbered automatically based on indentation level like:   1. Header  2. Header 2.1. sub header 2.2. sub header 2.2.1 sub sub header 3. header I actually wonder …
    2581 58
    Closed 2.6K views 58 comments Most recent by asisson113596 Archived 2015 Posts
  • Re: Task Alerts
    In Archived 2017 Posts
    I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…
    169 6
    Closed 169 views 6 comments Most recent by FEspo Archived 2017 Posts
  • Proofing Full Screen
    In Using Smartsheet
    When you initially send out a proof in Smartsheet you get a button to "Review Proof" which sends you to a full screen mode to review the image. However, whenever you got back to review that proof for that row it only opens it up…
    261 4
    261 views 4 comments Most recent by BrianBosché Using Smartsheet