-
Smartsheet-JIRA sync via formulas?
Hi guys. I'm using the Smartsheet-JIRA connector. I have a workflow where the Status of each JIRA ticket flows back into Smartsheet. Then formulas in Smartsheet change the Priority of a row once its predecessor is complete. The idea is that you have a bunch of tickets in JIRA that are marked as priority Blocked if they…
-
Usability of contact information
Does anyone know a way of using the contact information when a new contact name is up-loaded into the sheets? I specifically refer to the e-mail address, as i'm unable to copy and paste into an e-mail from that tab. To date i have just been using a separate column for e-mail addresses, but this seems to be doubling up on…
-
Setting a default format with Parent/Child Rows
Hello, Is it supported to set a default format for parent/child rows? For example, when a row becomes a parent, automatically * set text to bold * set text size == 16 * set the row background color to gray and * set the text to white. Thank you, Justin
-
Box.com Integration
This is an idea for an improvement to the box.com integration. Ideally, SmartSheet would allow attaching a document from my desktop directly to a row in SmartSheet while storing the document in Box.com. For example: 1. Drag and drop a document to a SmartSheet row / attachment. 2. Automatically create a folder in box.com…
-
Gantt Chart
Hi everyone, The Smart sheet is very good for short term projects. For a long term project that spans across more than ten years, is there a way to download a entire Gantt chart? Thanks, Liping
-
Project Plan formulas into new columns
I've been asked if there is a way to have the same functionality/formulas found in project plan columns (Start/Finish/Duration/Predecessors) into new columns. Basically, the project manager would like to set the initial project plan columns as the baseline, then add additional columns for projection and then more for…
-
Linking Cells from Columns to Rows / Transpose Paste Special
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several cells at a time, but it only links one cell - not the group of cells. So... I tried to bring in over as column to column and…
-
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
I would like to offer an idea to the Community to see if this has any support. There are plenty of examples of complaints throughout the community of sheets with complex formulas dogging down the sheet during saves. This can be exacerbated greatly by trying to move rows around the sheet, and the thousands of cell row…
-
How to automate RYG balls using two different column values.
I am attempting to automate the RYG balls using two different columns, the End Date and % Complete columns. The logic is as follows: 1. If the end date is greater than today, the RYG ball = Green IF([End date]2 > TODAY(), "Green" 2. If the % complete is greater than .99, the RYG ball = Green IF([% Complete]2 > .99, "Green"…
-
Validation
Dear Team, Kindly help with the date and email id validation. I want to put 10 digit number validation in mobile number column and @ in email id column.
