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 c…
I created a formula, but have problems. The formula is ........ =IF([Status Date]@row >= Today@row - 14, "Red", "Green") ....... The formula work fine in some rows, but not all. I'm puzzled as to why …
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 child…
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 easi…
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 Sm…
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…
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 bl…
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?
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 si…
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 …