-
Smartsheet/JIRA Connector: Errors during Sync (Proxy Errors)
Hi there: So we have a number of smartsheets linked to JIRA via the connector and over the past couple of days I've been receiving error emails that say "Invalid response from JIRA. statusCode: 502, reasonPhrase: Proxy Error statusCode: 502, reasonPhrase: Proxy Error" Assuming we need to contact JIRA/Atlassian about this…
-
Dynamic Durations
I would like to calculate the duration based on two tasks. For example, I want a start date from say task 1 to be the start date of Task 2, while the end date of Task 2, to be the start day of task 100. The duration should of Task 2 will now be the total number of days between task 1 and task 100. If I adjust Task 1 or…
-
Date validation on Web Form
Is there a way to validate a date before submitting a form. The Use-case is: We have an Event Request Date (Date field) on the form and we don't want the end client to select the close-by dates. We want to add a condition on the form; so, they can't select an Event day within a week, before they submit the form. Thanks J
-
Constructing URLs to particular rows in sheets
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / rows. The idea is that as the project SmartSheet gets extremely big and with multiple…
-
Tracking re-occuring assigned projects
For example if on a team I have 15 projects that are on going Assignment 1, 2, 3, 4 etc I want to assign primary, secondary , tertiary Then I want to have each person list how much time they spend a month in each of these roles Is there a template for this in smartsheet including formulas for adding hours per month per…
-
Error Message
Error message when trying to connect to Smartsheets remotely (this has only started happening the last few days). See the screen shots below. As smartsheets is in the cloud it does not seem correct that I should not be able to get to it via remote connection. I have using my Pernod laptop. First Message, says contact the…
-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
Can we please include widget for including iframe ?
Smartsheet community, I have tried smartsheet labs for the charts and have a live iframe to be embedded in the Dashboard but there is a no widget to include iframes. can we include this and do we have better options for charts and dashboards in smartsheets as i feel still a long way to go for better dashboards in…
-
Dash Boards
Can a dash board be designed to produce multiple information, like using a drop down to show each months Procurement's.
-
Average of multiple rows
Hi - I am running into a problem with finding the average of multiple rows based on the two previous columns. I want to return the average of all the rows in column Fall Rate that correspond with Month = 1 AND Year = 2018. This would then populate the 2017 and 2018 columns by Month on the other sheet. Any ideas would be…