-
Restrict a user's access to Dashboard only
I am new to Smartsheet but learning fast. We are starting a project to use Smartsheet for client onboarding to our software. I intend to create a client-facing dashboard but would like to restrict a user's access so they cannot click on the Home tab which they have no reason to view and is just a place for them to take a…
-
Calendar View
Hi, Smartsheet team: I would like to know what are the differences between the SS's the calendar view and the Calendar View App available for purchase. Is it possible to create a master calendar that gathers all the information of individual calendars into one place? Is there any chance to get a trial period for that app?
-
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…
