-
Project scheduling - moving from Excel
We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet. Here are some details: * We have 8 employees that can weld. * Some of the 8 can work on small parts, some can work on large parts, and some can work both. * Our Sales Orders may contain small parts, large parts or both. We list how much time…
-
stacked if formula based on DATE and Drop down
Good afternoon all I am fairly new to smartsheet but an intermediate user of Excel. For some reason, my multiple stacked IF OR formula for Dates is not working - i know it must be simple but ive been staring at it and really need some help Test Frequency is a drop down list: Daily/Weekly/Monthly/Quarterly/Yearly In a…
-
Best practice question
Hello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team * Risk Register report * Migration scheduling report * Dashboard for project health specific to their team What I want to…
-
Cross-Link Dependencies
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt…
-
Preserving Indents when running a Smartsheet Report
Hi, I currenlty have a smartsheet with a bunch of tasks broken out into different sections. I separate the sections with different field values but to help with readability- I also do indenting in the task description field- this allows for the summary tasks to show as bolded. My issue is when I run a report to show a…
-
SUMIFS, cross-sheet reference based on dates.
Sorry if this is a duplicate. I couldn't find an answer that fit my problem.. Formula: =SUMIFS({AccHours}, {ShipDate}, <=Date3, {completed}, <>"x") All references are from another sheet except Date3. Date3 is a formula as well, which is TODAY()+2. This works in Excel, but doesn't seem to work here. I don't get an error,…
-
Data derived from mulitple criteria
Hello Smartsheet Friends, I have a single text box that I'd like to do some data analysis on, and wondering if there is a way. My text box is similar to the below "Product, Engineering, IT, Supply Chain, etc......." I want to pull all of the instances of "Supply Chain" and do a sumif. Aka total number of submissions for…
-
Best method to update a project sheet
Hello everyone! I'm a project coordinator at a company specialized in manufacturing and installing irrigation systems, we have over 50 projects going on at the same time. We're trying Smartsheet to check whether it suits our needs, we're looking for a way to let a user supervising the project to update the progress…
-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
Predecessor formula
help me please I want to see in our project through a filter in which I specify: 1) If the status is not fulfilled 2) Deadline date in the past This is all I can do, but through the filter I need 3 points 3) All tasks that have a predecessor with a task number (which is not completed and overdue by date) This should all be…
