-
Smartsheet-Outlook Integration
I love the way this add-in speeds up the process of updating a Smartsheet row with email text and attachments. One gripe, though, finding the row that I want is not simple since I can only select full Smartsheets, which may have a large number of rows, many of which are not currently active.. Am I missing something? It…
-
Looking for ideas to improve my current daily process re: managing references
Hi all, This is a very open question to see if I can get ideas from the community to improve my daily morning process with Smartsheet. Apologies for the lengthy question- this is outside of my usual very specific help request. I'm responsible for our Company's data; in the property insurance- independent adjusting world.…
-
Excel @Text() Functionality in Smartsheet?
Is there a way in Smartsheet to use a formula that gives the same result as using @text() in Excel? I have a spreadsheet that I need to concatenate several fields together and have the field then display as text. Most of what I see now for formulas is to covert from text into formula. But I need to go the other way? Use…
-
Gantt Chart Alignment
I created a smartsheet using the Gantt chart template. For some reason the Gantt chart lines are slightly larger than the task lines. So when you're looking at a task and look right to see the gantt chart, it does not align with the proper task (Screenshot attached). This seems like Gantt 101 - The line has to match up…
-
Relational Smartsheets
I would love to be able to connect sheets via a unique ID that is common to the sheets. Making sheets relational would be very helpful because we could have multiple related sheets, and avoid having to add common fields across all sheets. I'm maturing a program using SS, and if I had the ability to relate sheets it would…
-
Recover Data Shuttle workflows
For large organizations, allow Admins to recover the sheets, automation workflows and data shuttle workflows created by users who have left the organization and assign them to other users who took over the respective role. Currently, the only option is to start over, which involves not only time and labor, but also…
-
Is there any way to select only specific columns to be included in alert messages that are sent out
Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are sent and included as…
-
How do I create a IF(AND formula combining multiple cross references?
In this screenshot I am sharing my rollup data sheet. Of the 6 Total Amex CB Count, I am trying to determine how many of those each of our Branches has but I keep getting different errors using formula: =COUNTIFS({Dispute & Chargeback intake sheet branch}, CONTAINS([Data Points]32, @cell), IF(AND({Dispute & Chargeback…
-
How can I add dividers in my dashboard?
Hello, I was hoping there would be a way to add dividers in my dashboard. Sharing the dashboard with our ELT, it could be easier to separate categories with line dividers that take up 1 square. Thank you, Paige
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…