-
formula to change upper case to all lower case?
I'm using an email address as an identifier from a survey/form to a smartsheet. For some reason, if the email address isn't all in lowercase letters, it doesn't recognize the user as completing the form (and their form data doesn't cross). Is there anyway to automatically change upper case letters to lower case from the…
-
Upper case for first letter of the word
Hi Team, Can you please confirm how to update the first letter to upper case. I have a formula that extracts the first name and last name from email id. so I am getting "gaurav" from gaurav.chauhan#amplity.com. I wish to change "gaurav" to "Gaurav" Thanks, Gaurav
-
Reports - Need an easier way to view all source sheet from the selection window.
Hello! We utilize a report that has 100+ source sheets. We've discovered a few sheets are missing and I need to cross reference a list of all the sheets that should be on the report with what is already on the report. Is there an easier way to do this besides scrolling through the list of 100+ sheets or having to type the…
-
Navigating to the source sheet from a report
I cannot find a way of navigating from the report to underlying source (apart from sheet name column, which messes up with the presentation - so I typically remove the column form the view). Plus, having the sheet name on each row is annoying. So in few other instances, I grouped a multi-sheet report by sheet name. The…
-
Smartsheet Bridge: Duplicate a Workflow
I think it would be extremely helpful to be able to copy/duplicate a workflow that you've created in Smartsheet Bridge in order to slightly modify it for another task without losing your original. Currently, the only way to do this would be to copy the same workflow into a different workspace. The issue with this is that…
-
Merging Community profiles
Hi @Genevieve P., Can you plrease assist me to merge my two Community profiles. One uses a shortened alias version of my email address and has most of my old discussion/idea threads. The other profile (this one) has my full name email address and now also has my product and sales certifications attached. I am hoping that I…
-
What is the best practice for referencing data in another sheet?
I currently have a Data Shuttle updating/replacing all cells in sheet 1. In a second sheet I have a formula that performs an Index/Match with the result coming from that first sheet. I noticed the cell history on the second sheet is capturing the first sheet values disappear and then come back in (example below). Assuming…
-
Save & Resume Update Requests + Automation for Unchanged Rows
I’m currently building a Client Health Report where CSMs provide monthly updates across their clients. Challenge #1: No “Save & Resume” for Update Requests Many CSMs manage a large number of accounts and don’t always have time to complete an update request in one sitting. Right now, they must submit everything at once,…
-
Need formula help
I'm trying to match info in another sheet and return a date column to the first sheet. I've tried a few things but keep getting errors. In Sheet A each row is a job number. I want to fill in the job completion date from Sheet B. It has many job number rows with different job types. The Job type column is Parent/Child. I'm…
-
Looking for an option to Exclude rows from Dependencies/Predecessors
Currently, the only way to exclude a row from the Dependency/Predecessor function is to delete the row. This causes any Dependency/Predecessor reference to the row to change to #REF, which does not break the associated date row, but skips the #REF. Preferably, we would like to keep all rows, but have an option to exclude…