Clear diamond in addition to a milestone marker?
I have a sheet that has a Gantt chart with milestones. The milestone marker I want displays appropriately. However, when I export to PDF, I also get a clear diamond at the far left of the Gantt chart. Can I get rid of the clear diamonds?
How do you get your source sheet to automatically send attachments to your target sheet
I am currently working on a project in which I would like to get my attachments on my source sheet to send to my target sheet once I click a checked box. I tried using Data Mesh and that worked for how I wanted my information transported over to the new sheet, but the documents did not copy over with it. Is this something…
Using the new customized sender in automations: Send from Smartsheet Automation
I thought this new feature would also update the reply-to email as a generic donotreply email address. But it looks like the reply-to email (at least for an alert type of automation) goes to the owner of the sheet. Is the only workaround to create a user with a generic donotreply email and transfer ownership to them?
Identifying successors of successors (and so on...)
Current status: I've successfully generated a "Successors" column, listing direct successors of each row, using the following formula: =JOIN(SUCCESSORS([Task Name]@row), ",") Current roadblock: My "successors" column only shows direct successors. I'm looking to create a column that lists ALL successors, all the way up the…
Adding RAG Status
What are recommendation on how to add the RAG (Red, Amber, Green) status on a dashboard via a widget?
One of the Sheets in my workspace keeps losing all of its data
Hello, I have 2 sheets currently in one workspace. The first sheet works as expected, it saves my changes when I save. The second sheet, I imported an Excel file to it. I made a couple of changes and saved. When I returned to the sheet it was blank. I did this three times with the same result. If I click into the other…
Trying to get data using the RIGHT formula
I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below. Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA) I use the RIGHT formula ... =RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row)) But I get the following string returned Result = -BEACH (ISPHUBS-6AAA) How do I get just the…
Perform SOX Documentation Requests
Hello, Is it possible to use the form tool to send requests for documentation? For example, I want to request documentation for a control, I want every field in the form already pre-filled out by the row of information, and I want the recipient to attach documentation based on the request description? It seems like forms…
New Window pop-up option
A recommendation I would like to make is adding a feature under widget behavior. When connecting a Smartsheet under widget behavior, it would be nice to have a check box or a toggle switch that asks if you would like a new window to pop-up whenever the widget is clicked. A new window pop-up is allowed if you copy and paste…
How to Set Up Tracking for customer builds - Recommendation for best Smartsheet approach
Hello Everyone, We have an item that is the same. We build it at customer locations and each build projects has the same milestones. We want to start using Smartsheets to plan and track each project and have 2 dashboards - 1 focused on the metrics of open projects and then one for tracking a "grade" per total project so…