Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
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…
Timestamp from a form
Hi, In Google, when a form is created, its associated sheet gets a column named "Timestamp." Whenever someone submits a form, the date and time is automatically generated into that column. Does anyone know if there is a way to have this feature in Smartsheet? I am using a form for enhancement requests for an internally…
Different working days per task
New smartsheet user here. I really like it! However, I need a way to change working days on a task level. Is this possible? For example, I have "cure time" for concrete finish work. The time is continuous regardless of holidays and non-working days. The concrete just sits and cures. Nothing else needs to happen.…
Why switch from MS Project to Smartsheet Project?
I'm new to Smartsheet and am considering in switching from MS Project to Smartsheet but there seem to be limitations: 1) Progress Lines - either I can't find it or there's no on/off for progress lines. it's quite messy when you have 1000s of entries. 2) Views - can't customize views based on users and audiences 3) Duration…
Dollar and Percent Symbols Not Showing
I've been playing with this for some time now but havent' figured out the way to have these symbols show up in my sheets. Would anyone here be able to point me in the right direction with this?
Prorate function and duration
Something seems to have happened with the prorate function in the new release, or perhaps it was always like this and I just never noticed (in which case I apologise). I use the prorate function to provide linear projections of task completion. In other words I calculate what the completion percentage of a task should be…
Work Hour Based Resource Planning
Hi; I'm working on resource planning for our projects right now and wonder if there is a way of planning based on working hours or based on periods of 1/4 days (not only based on work days)? Or if not; do you have plans for implementing such functionality?
Single day project duration
Can't see a way to do this yet... I want to create a project that lasts 24 hours. Individual tasks and to-dos need to be visible on the Gantt sheet in 5 minute blocks. At present I can't seem to zoom in any finer than one complete day. Is there a built in functionality here that can accomplish this?
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…
