-
Milestone Tracking Report - Numerous projects
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, complete and in progress data sets so that I can target the relevant stages inside of…
-
High Contrast and low vision
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. Most of the programs I use invert based on my PC settings, but not smartsheet. Let me…
-
access rights
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?
-
CloudFlare Blocking Issue
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 remove the links. It's still blocked. I wait 30 seconds, and then it's posted. Is anyone else…
-
External Inputs
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 of programs function in this way with SmartSheet? Is it limited in scope or is there a…
-
Document Checklist(s)
Hi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I need to be able to pull…
-
Highlighting Individual Cells Based On Date
I am trying to figure out how to highlight a cell based on how the status of the "actual" column is in accordance with the "Baseline" column. Is there a formula or conditional formatting rule to implement that will automatically change the color of the cell to green or red to illustrate that it is ahead or behind schedule?
-
Glitch Moves and Deletes Rows and Columns
Has anyone else experienced groups of rows and/or cells moving in their Smartsheets? It seems to happen overnight with 10-20 rows moving from the top of my Smartsheet to the bottom. This morning two columns were found deleted and Smartsheet doesn't have a revert function so I'll have to rebuild them. This has happened more…
-
Checklist for Airbnb Cleaners
Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure out how. Any advice would be appreciated! 1) This checklist will need to be filled out each clean. That means there needs to…
-
Sheet scrolling with mouse issue
Hi, I am unable to sheet scroll using my mouse. Pulling the side tag works but not with mouse since today. Any reason for this? Rgds Ian