-
Duration in Hours
I am testing SmartSheet in an effort to organize projects in our design and manufacturing company. Many of our projects have tasks that are less than a day in duration. We typically estimate jobs in hours. I have been testing the program using fractions for duration but when I link these tasks the program seems to allocate…
-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
statistics on multi projetcs
Hello, I am working on many project and my boss want me to say which task is finish in advance, in time or late compare to the initial date calculated. ex: when the project is finished we want to know which tasks are good and which are wrong. the task drawing start the 2015 01 01 and must be finish the 2015 01 30 if the…
-
Report refreshes inaccurately
We have a report linked to one sheet at a time, used to view relevant information without the distraction of all the details. We edit in the report and save. Sometimes we will edit in the sheet and save there. We run into two issues: 1) Edits in the sheet don't always pull into the report. 2) Some text/number fields can't…
-
Power Function from Excel
I converted a power function from excel "=0.8*(POWER((9600/1000),-0.5))" and once imported it comes up as an "unexpected opperator". Is there another work around?
-
Reminders based on multiple criteria
Hi, The only trigger available is based on dates which is fine but I need to add a condition such as "unless item closed". Do you know of a way I can achieve this, first of all is it a feature available? Thanks,
-
Create a Help Desk in Smartsheet?
Anyone have experience in creating a Help Desk in Smartsheet? We are trying to find a solution to give our customers a way to reach out to us with issues (not necessarily IT-related) and have the ability to track each. Anyone have a template they could share? Thank you in advance!
-
Multiple users in the same row
I understand that SmartSheet is great for sharing data and allowing multiple people to work in the same sheet at the same time. How does SmartSheet manage if 2 people are in the same row working? Is there a way to have rows lock when a user is in the row working? We had an issue where 2 users were in the same row working -…
-
Multipal projects using one resource pool
We use MS Project to manage over 30 projects using one resouce pool. We also cross link certain tasks between these project. eg. Every project has Engineering yet we can not work on them all at once thus we link between projects to create a good view of their schedule. I am not finding where Smart Sheet can do this. Then…
-
Rollup report missing rows
Can't figure this one out. Hoping someone can help. I have 6 sheets for various projects we are working on. Each sheet has at least one level of heirarchy and some have up to 3 (parent/child/grandchild?). I have used cell linking to create an "amalgamation" sheet that lists all of the projects with their related…