Is there a way to set a formula so all text in the column or sheet is upper case even if someone enters it on a form in lower or title case?
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
I have a sheet that is updated from an export from another system. One of the fields in the other system is for category and can have more than one category selected. So when the data exports it appears in Smartsheet as "Category 1, Category 2" - separated by a comma. I want to count all the rows with Category 1. Is there…
When we have automated alerts and actions based on triggers the email displays from: Smartsheet Alerts & Actions (automation@smartsheet.com). Is it possible to customize this? When I manually send an update request the email display shows as my name via Smartsheet - this is better. Ideally for the automated alerts we'd…
I am trying to create a RYG formula Have a drop down column with the choices: 75% staffing 50% staffing 25% staffing <25% staffing I want to say that IF([Staffing Level Impact to MEF]@row = "75% staffing", "Green", IF([Staffing Level Impact to MEF]@row = "50% staffing", "Yellow", IF(OR(([Staffing Level Impact to MEF]@row =…
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by different areas. One of the areas prefers to work in the edit form to see the information vertically…
I want to be able to have emails automatically be sent out 30 days prior to xx date for a sheet. I've been playing with the workflows and can get it to work but it needs a trigger. Whereas the "set reminder" can do what I want without a trigger but only goes out 14 days. Is there a way to get email notices based only on a…
有没有办法自动发送内容数据to another app or program to print custom Labels? Either with a button or maybe a checkbox in a "ready to print" field. Ideally this would be per row once info has been entered.
Is there a way to have a checkbox automatically checked if other columns with checkboxes get checked? I have 4 columns with checkboxes and instead of doing value columns for each one I would like to do a summary checkbox and just value one column. If that's not possible, can you set values for more than one column?