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. Archived 2017 Posts
Archives for May 2017
Discussion List
Allocations
Scenario 1 I have a task that happens every Tuesday but only takes 1hr of my time. I don’t want to create multiple rows to indicate this as one 1hr of the day, is there another way to do this? Scenario 2 I have task that happens with a span of 5 days but only takes 3 hrs how do i calculate that? Is there a way to do this?
Email Alerts Triggered From Text Column?
Is there a way to set up a sheet alert to send me an email 3 workdays after text is added to a specific column?
Need help with getting parent and sub parent data
I have a format that looks like this Project Name PreCon Name Name Construction Name I am looking for a formula that adds text to a column for each name structured as "Project Name - PreCon" or "Project Name - Construction" I can get it to work using explicit references =PARENT([Task Name]13) + " " + PARENT([Task Name]14)…
Gnatt Frustration
We need more control over scheduling to make this product useful. I just had an issue where after 200 some activities where entered with dates and it was realized it should be based on a 7 day week not 5 day. Switching to a 7 day changed all the end dates. In my view I should have been given the choice of adjusting the end…
Resource management seem half executed
I have 80 staff that I am looking to track. The current resource system seems very disjointed and not really useful. As an example I can't share a resource view, If I want to see what a person is assigned too I only get the sheet they appear in. All of my resource assignment is in the same sheet tracking each project so…
Resource Management across two companies
We have a parent company that shares a sheet with one of the departments within our business. We have a staff holiday planner to provide ourselves with resource management. Is their a way that this can be fed back to our parent company? Many thanks
Web form phone contact filling by customer missing number can it set formatting?
Web form phone contact filling by customer missing number can it set formatting? Due to our client typing through the form by themselves some time we can't control what they type. At this stage, for my case I just wonder is there a way to set the format condition to make the fill in data from this example Phone…
Automated Reminders
I have a sheet with tasks per row aligned to specific team members. Each row now has a reminder which is aligned with the due date column. Once the team member updates the row with a new due date, there is no new reminder set for the new due date. Can this be done automatically, so that when there's an update entered and…
Can smartsheet do this
I'm new here but have watched multiple webinars and read the getting started info. Before I invest a lot of time in this, I'm wondering if smartsheet has the ability to link two sheets with a one-to-many relationship. For my purposes, I'd like to have one sheet of open orders and another sheet of lineitems. There can be…
IFERROR -- Suppress Error Help Needed
Hello! I hope you're having a terrific day! I am looking for suggestions for using the IFERROR formula to suppress and error message. Here's the set-up: Columns: Planned Allocation = Out-of-Box Allocation column Planned Effort by Day = [Allocation] * 8 Duration = Out-of-Box Duration column Sum Planned Effort (Estimate) =…