-
Calculating average time spent in each phase
I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
-
At Risk Formula that utilizes end date and status columns only...
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…
-
How to use multiple IF and AND functions for symbol formula
Hello Everyone, I have a basic project sheet with Start Date, End Date, % Complete Columns. I would like a formula for Symbols to do the following: Gray = If todays date is less than Start Date Red = If todays date is greater than due date AND % Complete is less than 100 Yellow = If todays date is less than due date AND %…
-
How do I override a row in a secondary sheet when the info is updated in the master sheet?
I have a Master sheet where all of the data is stored. I also have other secondary sheets that have just the applicable columns for those groups of people. When I update a date or cell in the master sheet, is there a way to either just update that same column in the secondary sheet with the new info or copy the entire row…
-
Can I use DataShuttle to consolidate data?
I have many files that are formatted the same, but contain different data. I would like to use DataShuttle to consolidate the data into a single Smartsheet spreadsheet via an Upload Workflow. I simply want the data from each uploaded file to be added to the target sheet. Is this possible? Here is the process that I am…
-
Automated Data Export
Hey All, I have a problem that I have been struggling to find an efficient solution for regarding how to routinely get form data out of smartsheets. I am hoping for ideas, advice, and/or secure tools that you all may know of to help with that. For context, below is my current issue/goal and what I think is the best…
-
How to troubleshoot workflows deactivated due to an infinite loop?
The system notification that I get is not helpful at all. How do I figure out what I need to change to make my automations work?
-
Jira Integration - follow Row across sheets
I have a workflow for my team that uses 3 sheets. All requests come into the 'Intake' sheet using the Smartsheet form. Once approved, those rows are moved to the 'in progress' sheet. Once completed, those rows are moved to the 'completed' sheet. I have certain requests that require I engage a separate team which works out…
-
Assigning Contact Based on data in another sheet
Here's the rough scenario. I have 500 students who are divided up among 20+ teachers. When I choose a student in one column, I want to auto-assign their teacher in another column. I do this in Google Sheets with a formula, but wasn't sure how to go about it here. Let me know if you need more clarification. Thoughts? Gillian
-
Smartsheet Form - Latest entry is the only "actively" reported
Hi, I have a form for people to fill in that reports how ready they are for security. As this is evolving they can be expected to fill this in from time to time to measure how ready they are. So I only want the latest line from the form to be reported on. My system in place for this at the moment is to have a "Constant"…
