-
Alerts & Actions
Is there a way to create an alert for a row that hasn't been updated in a specific amount of days?
-
Modified Date and Conditional Formatting/Alerts
I have hit a problem that Smartsheet can't seem to deal with. My goal is to create a sheet that runs conditional formatting based on the differential between 'Modified date' and a TODAY equation. Firstly I tried to create a TODAY based formula in the conditional formatting tool. However, this acted as a figure once…
-
Epic to story issues from Jira
Hey all, I recetnly created a workflow with smartsheet and jira. All the issues seem to be imported with the stories under its respective epic indented. Later, when i linked some issues to its epic in jira and then refresh smartsheet i dont see those stories to get automatically indented under its epic. Do i have to do it…
-
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…
