Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
Formatting With a Range of Dates
I need to create a formula that looks at two different date fields and produces the result as a check (or no check) in a checkbox field. The two columns are: "Date Requested" and "Date Received." The expectation is that the "Date Received" will be 4-6 weeks after the "Date Requested." So basically, I need the box checked…
what is the best way to Integrate smartsheet into an Order based Manufacturing company ?
So i have been tasked with learning the In's and Out's of smartsheet and to find the best way to utilize all of its tools for our company. we currently do the majority of our work through GP which as an accounting program is great but doesnt have the best project managment capabilities. my Question is what would be the…
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!