-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
Expand / Collapse by One Hierarchy Level
It would help if one could expand or collapse everything by one step only rather than expand the whole descendants at once. Often I only need to expand/ collapse one step (up or down the hierarchy) at a time, and this means I have to manually expand or collapse each parent row to reach the next level, which is time…
-
Display Contact Name instead of full email
Hi everyone, Thank you for your time looking at this, I appreciate all the help and guidance I've received in this forum. Ok, here's my situation. I have an intake form and one of the entries is for the submitters name. The Field Setting is set to a Contact. After submitting the form, their name they typed in would appear…
-
Multiple Contact list with Request Update
I have found that I can not include a Contact list column which is set to Allow multiple contacts in a automated request an update action. If you include the contact list column, none of the specified fields will show up and the open request web page only has the message, no submit or field list. The only work around I…
-
Master Sheet with Thousands of Rows
Hi All! I have multiple sheets that are tied to specific team members on my team. Each sheet has the same columns. I'm currently trying to see if there's a better way to organize this data. Right now, 12 sheets are managed individually by each team member and then when a row is resolved, it gets moved to a "resolved"…
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
Reverse Geocoding
I am using a form with the pin drop to track sales employees in person visits / cold calls. The return value in my data sheet is the location coordinates hyperlink that takes you to Google Maps. Is there a way I can extract the address information from the coordinates into a separate column on my sheet? I have an…
-
Bridge - Pull Multiple contacts from one sheet & update one cell with all?
I am trying to use Bridge to pull all the contacts (Supervisors) from a roster grid that match the department defined by my trigger and then put all of these contacts into one single cell on my project tracking grid. So far, I've been able to get the array and then extract the emails I would need but there's a couple…
-
Knowledge Base to Onboarding
I am setting out on a path to utilize Smartsheet as a Knowledge Base platform for our department. Just as the brain is made up of many parts and connective tissue, so are the functional roles of the business. Smartsheet does integrate video, SharePoint and Lucidchart which conveniently reduces Phase 1 setup. Phase 1 -…
-
COUNTIF and HAS functions not working on multiselect columns
Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard. Any ideas on what I'm doing wrong?