Discussion List

  • Use Formula to Check Checkbox as a Column Formula
    In Formulas and Functions
    I found this formula in the community that works perfectly to check the box if there is any text in certain cells. =IF(OR(ISTEXT([Column1]@row), ISTEXT([Column2]@row), ISTEXT([Column3]@row), ISTEXT([Column4]@row)), 1, 0) I'm getting a col…
    29 7
    Answered ✓ 29 views 7 comments Most recent by Bessie Koch Formulas and Functions
  • Formula is not persisting when value is removed from cell
    In Using Smartsheet
    Hello, We are having an issue with cell formulas. The cell formula is erased when we change or delete a value in a cell. Here is the formula we are using: =IF(Status4 = "Complete", "In Progress") The formula should fir…
    Answered - Pending Review
    17 3
    Answered - Pending Review 17 views 3 comments Most recent by Jon Mark H Using Smartsheet
  • Forced to upgrade
    In Using Smartsheet
    I had recently bought a Pro plan and after about a month, a lot of the features that I had been using frequently (which was available on the pro plan) are blocked and now I'm being forced to upgrade to a business plan. I feel this is unet…
    Answered - Pending Review
    43 7
    Answered - Pending Review 43 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Parent Rows in Report
    In Using Smartsheet
    Hello, I have a made a current user report which shows only tasks where the current user needs to update. However I need the parent rows to show above the current user which may not be assigned to the same user. Is there any way to show …
    Answered - Pending Review
    31 2
    Answered - Pending Review 31 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Column Highlight
    In Using Smartsheet
    is there the ability to colour in a column not a row to show for example UK bank holidays or staff holidays etc.. to show in a very quick visual way any clashes that might be avoided.  
    403 6
    403 views 6 comments Most recent by J.Po Using Smartsheet
  • 404 Error - Event data - Smartsheet API
    In API & Developers
    Hi, I am attempting to get event data from the smartsheet api. First, I tried the new api documentation method which suggests a request to the event api url. Traditionally, you don't pass both a parameters variable AND parameters in the u…
    40 3
    Answered ✓ 40 views 3 comments Most recent by Andrée Starå API & Developers
  • Formula: if checkbox is checked then add or subtract
    In Formulas and Functions
    Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse.  The idea is that employees report via a dashboard whether they are taking something out of stock or returning something.  If one checks …
    49 4
    Answered ✓ 49 views 4 comments Most recent by Genevieve P. Formulas and Functions
  • Card View for Reports
    In Using Smartsheet
    Any idea when or if we will see Card View on Reports in the near future?  If not, I'd like to add my vote for this feature as soon as possible; it would be very useful to our workflow.  Thanks.
    351 12
    351 views 12 comments Most recent by Andrée Starå Using Smartsheet
  • Form Validation - Phone Number Default to Canada?
    In Using Smartsheet
    Thought I would ask here before contacting Smartsheet Support (as I'm hoping someone else has had this problem, and has a resolution). I've built my form, and added 'Phone' as the Validation. The problem I'm facing, is that I've changed …
    57 1
    Answered ✓ 57 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Help with SUMIF Formula
    In Formulas and Functions
    Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Wo…
    15 2
    Answered ✓ 15 views 2 comments Most recent by Chloe MB Formulas and Functions