-
Usability Problems on Big Sheet
HELLO I HAVE AN USABILITY PROBLEM CURRENTLY OUR MAIN SHEET (ADMIN_2021) IS ONLY USING 41% OF CAPACITY, ACCORDING TO THE REPORTS OF EACH SHEET. INFACT WE HAVE 204.000 ACTIVE CELLS TO DATE (CURRENTLY USING 51 COLUMNS AND 4000 ROWS ) I AM THE OWNER OF THE SHEET, WITH A TOTAL OF 3 ADMINISTRATORS, 4 EDITORS, AND 2 OBSERVERS.…
-
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…
-
Relating sheets many to many
Hi there. I am trying to design a set of sheets in Smartsheet to allow two different types of projects to be related to one another. I have species projects in one sheet and site projects in another sheet. I want to relate these two sheets such that one species can be related to multiple sites and one site can be related…
-
Aggregate Status Circles w/ Formula
Hi, I have these multiple statuses across 4 projects (each project is one of the rows) within 1 program and I want to be able to incorporate a formula where I can summarize all of these to a single row with the same columns in a separate sheet to present at the program level. Formula to say: If there's at least 1 yellow…
-
Changing data on a survey that has already been submitted?
Hello - I have a question about a mistake I made on my survey. I have one sheet that holds 6 survey forms. I have a unique identifier that is hidden from the respondent but will let me know which survey the response is for when it fills into my sheet. I just realized I duplicated the unique identifier on two of my surveys…
-
Current year streak and rolling unbroken streak formula help
I have a dashboard metric that I could use help with. I have a Consistency Club to recognize associates that achieve their monthly sales activity metrics, measured by individual month. Meaning if they have achieved their metrics for Jan, Feb, Mar, Apr, May and June their current year consistency streak would be 6. If the…
-
Recommended format
Hi there, I'm looking to track daily activities of field staff. This involves broadly tracking daily tasks but perhaps more importantly location of staff in the field (who is where and when) and the work vehicle they are using (we have about 13 that are shared among staff). How would you recommend approaching this? Thank…
-
Color code Gantt bar
Hi there! I'm looking to code the color of Gantt bars based on the value of a different colum, called "Location". Is there a way to do this? Thank you, Esperanza
-
2 or more projects sheet dependency
HI, I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sheet. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> For example: Project A sheet Task # 25 on…
-
Assigna mail adress automaticly
Hi there ; İ would like to get your advices about below issue , i have a column that i enter names ( colum name "Responsible") , near responsible column there is one column too (colum name "mail adresses" ) , is it possible that when i enter person name , mail adress will be written automaticly , these people that i add to…
