Sheets
Discussion List
-
Relating sheets many to manyIn Using SmartsheetHi 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 she…
-
Hourly view on Gantt ViewIn Using SmartsheetHi there, We have a project with vehicles moving across multiple locations and would like to keep tract of their activity by the hour. We don't so much need to track their GPS location as much as, Car # 1 is in Town A, and then needs to g…
-
Changing data on a survey that has already been submitted?In Using SmartsheetHello - 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 in…
-
"When Triggered" Automations BehaviourIn Using SmartsheetA colleague of mine has sent me a question that has stumped me and has got me thinking my understanding of how automations work has been wrong. She sent me the following: We have automations that are set up to send when triggered that sen…
-
Hi There, I have a column with comma separated strings. How to find the occurrence of each string?In Formulas and FunctionsPlease see the below table. I have 20,000 responses. I need to find out how many times each response was given. I have 20000 responses. I need to find out how many times each response was given. Thank You.Answered - Pending Review 23 views 6 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Can you use Groups in Contact list column type?In Using SmartsheetWe have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the…
-
Current year streak and rolling unbroken streak formula helpIn Formulas and FunctionsI 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,…Answered - Pending Review 39 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Recommended formatIn Using SmartsheetHi 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 ab…
-
Color code Gantt barIn Using SmartsheetHi 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 dependencyIn Using SmartsheetHI, 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 sh…
