-
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…
-
Is there any way to save the work while updating using the web form?
Is there any way to save the work while updating using the web form? Looks like people have to finish all the updates at one time otherwise it won't be saved. On the other hand, if you submit the updates before you finish it, you won't have the access to the update anymore. Thanks!
-
Automated Row to bring up
Is there a way to automatically bring up rows that are in the bottom of the sheet? for ex: bunch of tasks that are live, done and on hold respectively. Is there a automated way to bring the live rows up, done rows at the bottom and on hold rows in the middle? I can do this with a report but was just wondering if I can…
-
Auto Number Columns Based on Other Column Input
Is it possible to link the auto number format to data in other columns? For instance, if the user selects a particular product type in a form (Soda, Water, Juice), can I create an auto number column format that looks like Soda-001 or Juice-001? Thanks
-
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…
-
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"…
-
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
-
Linking Cells from a Vertical Orientation to a Horizontal Orientation
Hello everyone, I am creating a Project Pipeline which consists of many linked cells from many different individual project sheets. The individual project sheets are designed in a way that the information I am accessing is vertical. But in my pipeline, these same values need to be horizontally displayed. I need to link…
-
Multifamily Unit Turn Management Template
Good afternoon, Does anyone have (and if so are you willing to share) a template for keeping track of unit turns at an apartment complex? Thanks!
-
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