Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Jira Connector uploading Duration in Seconds
Something has changed. I had a JIRA Connector working well, exchanging task duration in days from a JIRA Field, and a Duration Column in my Smartsheet and something changed The connector now populates my mapped JIRA field using seconds rather than days. It used to populate the JIRA field in days, just the way it was…
Cell Linking Blank Templates
I'm looking to create a "Packet" of 3 sheets that cell link together to be used for multiple projects. Is it possible to create 2-3 Blank Templates set up to cell link with one another, without it getting altered when the blank template is used again for a different project? Hopefully this explaination makes sense. Thanks…
Not a Lisenced Administrator
Hi there I have only tree Lisenced Administrator on my company. I wanted to know... if the other people at the office can be sheet owners for what lap of time? Is there a time limit for them to be sheet owners? Because one of us was been sheet owner but the other day he couldn't do no more. Does smart sheet has some kind…
Reporting from two completely different sheets
I have inheritied two sheets that have the same primary column (project name) but the rest of the columns are completely different. Is it possible to combine parts of these into a summary report? I want the report to have one row for each project listed in the primary column. In my current attempt the projects show twice…
Establishing connection between Informatica Power Center and Smartsheet
Establishing connection between Informatica Power Center and Smartsheet
Insert Time Stamp
Is there a way to insert a timestamp into smartsheet when a specific field has updated? I would create a column that it can be stored in I just don't want to have to have the team manually update it. I need to be able to see what was completed yesterday. thanks
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!
Multi-Layer Gantt Chart
Hello, I'd like to create a Gantt chart which allows me to layer an original date range and an actual date range. This way, I would be able to show how a schedule has changed against an original base line. Ideally, i'd like to be able to see the original date as one color, and the actual date as a slightly different color,…
Webform send automatically
Hi, is there a way to send a webform automatically. https://app.smartsheet.com/b/form?ffff&Element=123 will set the Field "Element" with 123. Maybe it's possible to send somthing like &Submit=True or so. For what: I will sign my elements with QR Code and want the employees to scan the Code with nothing else to do. Date of…
Using COUNTIF or SUMIF to evaluate a date range
Hi, so I have a ColumnA that has random dates for the current year 2017. The column is formatted as a "Date" style column. My goal is to sum each date in this ColumnA by Month: Example: So to the right of each date, I want the sum of all dates that are in "January" that are in Column A. Thanks