-
Symbols suggestion...
Okay - so mostly in jest, but a few of us would love a "Whack-a-mole" type icon to put on the rows of a few who are forgetting to get their project updated. Just wanted to toss that out there for others who might have the same problems - wer'e in this together, folks!! SOLIDARITY FOR SMARTSHEET!!!
-
Impact analysis/Traceability?
I'm wondering how one would address this for managing changes to projects? For instance, in tools I've used in the past, I can answer the question "for the tasks/requirements that are at risk/due soon what would be impacted if it weren't completed?" and or "If I change this item, what is the ripple effect to my other…
-
Send Row Feature - Remove Log In button?
I'd like to be able to send rows to people that are not users in our SmartSheet account, but fill out a form that populates rows in our sheet. Is there a way to remove the Log In button in the header of the "Quick Update" email that goes out when you "send row"? I like the logo that is left justified in the header, but…
-
Universal Conditional Formatting Across All Sheets
Hi, Is there way to have a conditinal format rule apply across an entire database? For exampe, i have a collegue whose name I want to highlight in yellow so it it easy to see on any project (sheet) he is working on. I want to avoid adding the conditional formatting rule to each sheet he appears on. Is it possible to make…
-
Conditional sharing of row data from one sheet to another
We have divisions that have an HR function. Each HR function has their own Smartsheet to monitor salary action data. Certain salary actions require approval from the Central Office. Is there a way to conditionally share specific rows from a Division Sheet onto a Central Office sheet? It seems the only way so far is if the…
-
Bookkeeping
Hi, I have just found smartsheet and it looks amazing.. :) I was wondering how I can work it so that not all of my contractors can see all clients? Should I create a sheet for each contractor? or do only the invited contractors see only their clients? Thanking you in advance ps: I thought the Financial Month End Smartsheet…
-
Formula help
Well - I have the formula right if I don't place it in the referenced cell. However, I'd love to be able to put this formula in the "Status" column cell it is referencing to avoid adding another column. Help? =IF(ISBLANK(Status1112), "Active") I have 1800 columns that need this formula added, so I can't wait to get it in…
-
Import discussions items
Is there a way to mass import discussion items - I know they can be exported - but can they be imported?
-
Tracking the number of project work dates of multiple projects on one calendar
Hi, I am a new user of Smartsheet. I work for a Conservation Corps, where our contracts indicate total number of work days, and the actual work dates vary and move around based on our daily staffing and the sponsor's needs. It only matters that our projects are completed by the end of the fiscal year. I need to track total…
-
Cell Restrictions
Hi there Does anyone know whether you can add restrictions to cells (or columns/rows) to specify the number of characters/words used? For example, i'd like to restrict some cells to a maximum of 30 words, to ensure people don't input excessive descriptions. thank you!
