-
How do I auto-save a sheet without opening the sheet?
I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.
-
Sheet Glitch question - Text delete / Missing after inactivity
Hello I noticed something odd recently. I would highlight a text in the primary row and was evaluating my sheet for some time. After a moment, the highlighted text would disappear and the cursor would change to input text. I would not input text, but the previous text would disappear. I found that if I select "ESC" it…
-
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
