-
Helper columns
Hi there, Is there a tutorial on helper columns? Helper columns have been suggested to me, and I'm sure they will help our group but I am still confused on how to use them. Thank you! Esperanza
-
How to add conditional formatting to Gantt Chart in Smartsheet?
Hello All, I am preparing a project gantt chart using Smartheet. I have few questions: Can we set up a condition to highlight the gantt chart bar in case there is a delay in the completion of a task? If yes, how?? Can we change colour or highlight any text through conditional formatting in case there is any changes in the…
-
Using Contact List Column after Form is Complete
So I have been through the forum and know that currently the contact list is not available in forms unless you add a drop down list of names for someone to select. This isn't possible for me because the maintenance of this would be crazy. What I wanted to know was, after the form is complete and someone enters their name…
-
Using Microsoft Flow to update an excel sheet when a Smartsheet is updated
I have been searching and trying out with Microsoft Flow to update an excel sheet in SharePoint, when triggered by "When a sheet is updated - Smartsheet". However, no matter how I try, I am not able to get the specific row data values. I could only retrieve information of that sheet, for example modified date or name of…
-
Use same contact list on multiple sheets
I'm looking for a way to have the same contact list on multiple different sheets. The ideal situation would be to have a contact list sheet where we update contact information and then use the values from the {name} column to populate the contact drop down... Is there anyway of doing this? Another thought I had was just to…
-
How can I stop a "send as attachment" email notification on a deleted report?
I had set up a weekly schedule to send a report as an attachment for a team member. This team member has now left the team, and I deleted this report as it was only relevant to them. I assumed that would end the weekly notification emails being sent to them, or I didn't really give it a second thought since that email…
-
Smartsheet/Jira Connector - The connector stopped working for "Sprint Name"
I have been using the smartsheet/jira connector for months now and it seemed to work normally. We had the fields from Jira updated on smartsheet and vice versa. Recently, "sprint name" has not been working. The sprint name still displays on Jira, however, it is not being communicated on Smartsheet. I don't think any…
-
Hyperlink a word document?
Am I able to hyperlink a document, for ex. a Microsoft word or excel document into a cell and have it open up the file? If so, is this able to be done if the file is on a shared network server?
-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother 's sheet. I added a new last row but the Links to the secondary sheet are missing.…
-
I need to lookup a column on one sheet and reference a column and value on another sheet.
I have a Model# on sheet 1. I need to search for the same Model# on sheet 2 and if found, look at that Model's status and return that value to sheet 1. Caveat: the Model Status on sheet 2 is a drop down list (Complete, Not Complete), so I need whatever value is selected to pull into sheet 1. I tried a VLOOKUP using the…