-
Is there a way to stop 100% completed tasks still showing in Resource Views
We use Resource Views to show capacity loading for each department in our factory. Not sure if this is possible, but it would make sense to me if when tasks allocated to a particular resource were marked 100% complete they would no longer show/contribute to the loading of that resource. If a completed task dropped off the…
-
Help: #INCORRECT ARGUMENT SET
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLANK([2nd PRODUCT OWNER APPROVAL]@row), "", IF(AND([1st PRODUCT_OWNER APPROVAL]@row = "APPROVED",…
-
Project Management: Automating Timelines Across Multiple Projects/Sheets
Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it plan to, it's just the only product I've heard of that has this functionality out of the box.)…
-
Formula to lookup and display date based on specific task
I need to report a GO Live date on various dashboards. The problem is the go live date is not in a static row and can move up or down in the project plan based on tasks. I assumed that I could use the vlookup to find the "Go live" task and display the date but using this formula, nothing displays. I dont get an error of…
-
Microsoft Office 365 Planner support
What I'd love is for an assigned task to create a new Planner task and be linked together when changes happen to either side they update each other. Primary use case is that the majority of people who will access Smartsheet in our company will have other tasks they need to keep track of in the organization through Planner…
-
Automated Workflow Emails Look Like Span
Can I change the heading of an automated workflow email so it does not look so much like spam? I would prefer it to look like I sent the email and not the automated system.
-
Drop Down List Data Validation
My team and I are new to Smartsheet, and after 2 days of using the software, have already found a couple of major road blocks that will likely keep us from using Smartsheet. The biggest is the inability to create a drop down list that uses data validation to pull a list of options from another Sheet. (Example - one sheet…
-
Can I change tasks visibility in a shared smartsheet?
Hi, I am trying to find out the best way to work with smartsheet in a particular scenario. I have project smartsheets that outline project milestones, and tasks within. This sheet is shared externally to my team for collaboration. In many cases, some of the tasks might drive subtasks, or small actions that the internal…
-
Build Gantt Chart based on JIRA User Stories Story Points estimations
User story in Jira are estimated in Story Points (0.5, 1, 2, 3, 5, 8, 13, 21...) where each story point can be mapped to ideal days range such as a 0.5 story point = 1d, 1 story point: =2d 2 story points = 3d 3 story points = 5d ... Theoretically it is possible to build a gantt chart of the N user stories as follow User…
-
Formula to check a box when date entered + 2 days
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row. For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours for stain, etc to cure before project is technically complete. This is the formula…