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
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…
Alerts not moving over with a 'Save as New' sheet or using a Template
Is there a way to also include existing Alerts (Notifications and Reminders) when creating a new smartsheet from another Smartsheet or from a Template?
Grouping and Sorting
Hello, Coming from a project planning background I am used to being able to chose how I group my plans. Is it possible in smartsheet to group say by who a task is assigned too? I understand the way the indent function works and the way you can filter on "Assigned Too" if I wanted, but for eg I might want to view my full…
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…
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.
Highlighting/Colouring Sundays in Gantt Chart
Hello, I want to colour all Sunday columns in a different colour than Monday to Saturday in my Gantt Chart Just like in the following Image; there are the Saturdays and Sundays with a grey background. EDIT: Okay, I got the issue. I also highlighted the rows of the main-tasks and its child-tasks in several colours (Task 1 +…
Finding the latest date of certain tasks based of those tasks' attributes
Hello, I'm looking to find the latest end date for certain tasks based off of attributes in those tasks' rows. For example: If I want to find the latest date of tasks in cycle 1 of a release (but not cycle 2), and within that there are 5 different categories of tasks but I only want to know the latest end date of one of…
Adding Time Values
New to smart sheet but couldn't find an answer to this question! Is there a way to add several time values to a total (ex. :15 + :15 = :30)? My goal is to sum all overtime minutes worked during the week into a running yearly total. On my spreadsheet I have a Total YTD Hours Column, A column for each day of the week that…
Jira connector - Update sprint from smartsheet
Why can't I update the sprint of my Jira tasks created from smartsheets directly from smartsheet itself. Why cant I create new fix versions from my smartsheet itself
Calculating Variances with Negative Numbers
How do I do this on Smartsheet? I have an Actuals and a Budgets column. I'd like to compare the 2. So for example, if you have a Budget of 100, and an Actual of 70, then the variance would be -30%. IFERROR((Actual-Target)/Target,0) is all good for positive numbers but I need to ensure it also works for negative numbers. In…
