-
printing gantts, printing stuck on quarters
When I attempt to print a gantt chart, the printed version always shows the dates in quarters, even when I am viewing weeks or months. How do I get the printed version to match what I am viewing?
-
% complete based on count of child checkboxes.
I'm hoping someone can help me. I have a sheet set as a grid with a list of tasks for designers to do, these are divided into 4 categories, with the tasks being indented beneath the parent category, I have a column called 'complete' that is checkboxes which the designer check once each task is compete, so like a regular…
-
Send update requests to assigned user?
Is it possible to send an update request to the user assigned to the row? For example, I have five tasks listed on my sheet, each assigned to a different user. I would like to select all five rows and hit 'Send Update Request' and use the 'Assigned to' column to determine who it should go to. Having to re-type the…
-
Production/task management with sales order taking
We are a small custom sign manufacturing company. Our clients can order any number of products at a time ranging from small items to custom furniture. All have a similar start to finish process with some customization along the way. We would like sales reps to be able to enter orders directly into a page with details on…
-
Using COUNTIFS across multiple columns for one criteria
Hello All, I hope you are all doing well. I'm trying to use the Countifs formula by referencing our Portfolio Project sheet. I'm using five columns. One column is the project status which I am limiting to those projects with a status of "In Progress" (Range 1). The other four columns are columns that I titled, Project…
-
Smartsheet overrides workflow approval
I have a multi-step workflow approval set up. Form entry submission sends an initial request to the manager. When manager approves, next approval goes to center administrator. Once that's submitted, then it goes to one more and then the director. Problem is that smartsheet is overriding the "Approved" status from…
-
Help on fiormula: countifs
Hi all, please need your advice for the correct formula for getting the count of projects that are active within a specific month? We would like to track the number of projects that are still active for 2018. I'm trying the formula below but I'm getting an #INCORRECT ARGUMENT error. =COUNTIFS(Stage:Stage, [Forecasted End…
-
Days Remaining Calculation
How do I set a date in the future and then count down the remaining days until that date? For example, my future date is 8/17/18 and each day I want it to show how many days are remaining until 8/17/18.
-
Number of Days Ticket is Open
Hello all. I am a newbiw to Smartsheet, and I'm having trouble correctly adding a formula to one of my sheets. I have a repair sheet with a column that shows the date the ticket was created and a column that is labled number of days open. How can I have this column automatically display the number of days the ticket is…
-
Dates - Gantt Chart
I'm building out a plan with tasks and dependencies and want the dates to populate based off a vlookup. For example, If "Sprint 12" is selected then the proper start date is set in the Sprint Start Date column...which I am doing now with =VLOOKUP([Sprint Start]4, $[Sprint Start]$123:$[Sprint End Date]$136, 3, false). The…