Community Platform

Discussion List

  • Date Problem
    In Formulas and Functions
    I recently ran into a problem with dates. I did not realize that “mm/dd/yy” hard coded in a date formula would be an issue in a Date Column. But when I tried to use the “mm/dd/yy” populated date for comparison with another date, I kept get…
    343 1
    343 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Troubleshooting formula and or row
    In Formulas and Functions
    I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= [email protected] - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why this is the case…
    384 11
    384 views 11 comments Most recent by Paul Newcome Formulas and Functions
  • Showing Only the Parent Rows in a Dashboard Chart
    In Formulas and Functions
    Hi - I have created a dashboard to show pie charts of my data. My problem is that the pie chart wants to include every single row as a data point, I only want to show the parent rows and not the children. I used the formula "=Count(An…
    389 5
    389 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Sheet content, shifting rows
    In Using Smartsheet
    Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easier). Today, I noticed that the columns…
    13 2
    13 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Date and/or time stamp solution
    In Formulas and Functions
    We use Smartsheet in many wonderful ways but, in my opinion, the lack of a method to easily lock a cell with a date and/or time stamp is an open door for a competitors raid. A few years ago, I left Smartsheet because images could not be ex…
    90 2
    90 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Milestone Tracking Report - Numerous projects
    In API & Developers
    Hi all  I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, …
    122 1
    122 views 1 comment Most recent by Andrée Starå API & Developers
  • High Contrast and low vision
    In Using Smartsheet
    Hey smartsheeters! I use smartsheet(s) everyday and I have a rare retina disease that makes the bright white screens hard to read, is there a way to invert the screen colors? A nice bland gray with black or white letters would be lovely.…
    171 3
    171 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • access rights
    In Using Smartsheet
    I need to give access rights only to certain people to edit a particular column in a unfiltered worksheet, All the info in the worksheet needs to be visible to all the members. Can this be done?
    12 1
    12 views 1 comment Most recent by Kyle Zulpo Using Smartsheet
  • CloudFlare Blocking Issue
    In Using Smartsheet
    Hi everyone, I have trouble answering the Community Posts because I get blocked by CloudFlare. I can't see a clear pattern to why.  Has something changed? I try to link to other helpful articles and similar, and it gets blocked. I remov…
    71 9
    71 views 9 comments Most recent by Andrée Starå Using Smartsheet
  • External Inputs
    In Using Smartsheet
    What types, if any, of external input from other programs is SmartSheet capable of handling/using? IE, is there a way to set up a sheet so that whenever a certain program updates its information your sheet does as well?  If so, what types…
    31 5
    31 views 5 comments Most recent by Andrée Starå Using Smartsheet