-
Template: Team Task List by Priority
Hi Everyone, I'm new to Smartsheet. In the Template titled Team Task List by Priority, there are headers. High Priority, Medium Priority, Low Priority and Completed. My question is: how do the tasks in lines below the priorities get assigned to which priority? Do they get auto-populated to each priority based on something?…
-
Sharing within a Workspace
I have some folders setup in a workspace. In the column 'Sharing' for the folders, it says 'Workspace'. In the 'Workspace Shared To:' list, it shows three users.. Somehow all users can see the items in the folder, not just the three users in the 'workspace shared to' list. How do I restrict these folders? Thanks!
-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
-
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…
-
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…
-
Project sheet multiple users restricted data view
I have a question , If I create a sheet to track the tasks done by my team, is there a way where i can have that when each member accesses the sheet, they can only see their own inputed data, but for the admin he can see the full sheet without any problems ?
-
Portfolio Reporting
I am new to Smartsheet and my goal is to have a dashboard for our PMO with links to the various projects. Each project may be led by different people in the company. Do you have suggestions on how to set up the Dashboard for automatic roll up of information? I have found some helpful articles here, but I would love to know…
-
SmarSheet Expiring for shared user and requiring subscription
Team! One of my clients is reluctant to use SmartSheets because she claims that when I share access and a certain amount of time has passed that she is required to purchase a subscription to SmartSheets. Is this true? I cannot find any documentation that supports this. Thanks.
-
Password Change Policy
Is there a way to set a password change policy? For example, I want people to change their passwords every 90 days. Can I set that to happen automatically?
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…