-
Column with Remaining Days
Can a column be added that can display the remaining days of a task ? and How can be this done. Thanks
-
web form for order form
I'm new to Smartsheet. Have created a sheet with a web form to be an order form for our customers. In part of the form I'm wanting to provide our customers with the functionality of entering quantities for our various products, how do I do that? Thanks :)
-
When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?
I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…
-
Need help with an IF AND statement
=IF(AND([Required Weld Size]4 = 0.25, [Actual Weld Size1]4 = 0.5, 0, 1)) I am not able to get the above working. IT comes back imbalaced and I have played around with it with not luck. Can anyone lend a thought?
-
Formula Help
Hi. I am a project manager for a design build company and I am creating a template to use to forcast the labour required on a job that automatically decreases based on the percentage complete. I am wanting to add a formula to one of my sheets that will automatically populate up to 4 column cells based on an option chosen…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Formulas and Data Rollup
Hi, I am in the process of putting together a sheet that logs the amount of production each day. As a bit of background we are an aggregate manufacturing and contracting business and what i am trying to do is have a sheet that tracks the amount of production of each product per day. I have created a sheet with all the…
-
Share resources between accounts
We have 2 different smart sheet accounts so we can brand them differently. The two different brands share resources. Is there a way that we can share resources between the two accounts? At the moment if a sheet is shared from brand A to brand B and then a manager from brand B assigns a resource; that resource use does not…
-
Removing the "d" from the end of a numerical calculation
Is it possible to remove the "d" from the auto calculated columns? For example I have an open date and close date and I want to know how many days it took to close that item.. when it auto calculates that item it adds a "d" at the end of the number. When I export the file to excel to review the data I have to manually…
-
Sheet Size
I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the top. I have done alot of work to all of my sheets and some have had to be divided. If…