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. Archived 2017 Posts
Archives for March 2017
Discussion List
Best practices for managing offshore team task and schedule?
We need to overcommunicate and manage our offshore teams better. What are best practices in terms of tracking and managing ALL the schedule and tasks using Smartsheet? One master schedule containing the details of every task (which we want individuals to go in and update status with comment)? Or separate the schedule from…
What's the best way to show Baseline Schedule when it's not available on the Gantt?
We are using the Baseline "workaround" by creating the Actual Start, Actual Finish and variance column formulas. What method has worked for you to compare the baseline to the actual since it's not supported in Gannt view? *already upvoted this feature!
Report when scanned code
Is it possible to get a report / notification in SmartSheet if a qr-code or any other code is scanned by a smartphone (android or iPhone)?
Reports - Using formulas against reported data to pull into SIGHTS?
Hello, Was unable to find this topic and for some reason thought report 'formulas' was on the 2017 roadmap for March but on couldn't find the community or annoucement so here I am. I have a report pulling from several project plans. Within the report I'd like to summarize the reported data using formulas. example:…
Transferring information from one sheet to another when checkbox checked
I have a system whereby people are able to report issues by completing a form through smartsheet. Once the issues are clarified or resolved, I want to release certain information to other parties, but not all of it. I would like to be able to check a checkbox that says "release" and this will then trigger a transfer of…
Rolling Week View in a Report
We have a smartsheet with multiple rows of activities and column headers: "PSA Start" and "PSA End" dates. We want to build 3 reports that shows: (1) PSA End dates due in 0-2 weeks (2) PSA End dates due in 2-4 weeks and (3) due in 4-8+ weeks. Can this be done directly from the report or will I have to create calculations…
Multiple predecessors
I am new to smartsheet. It's a great tool but have run into difficulty working this out. I need to apply 2 predecessors to a task. One being that the task has to be completed no less than 2 weeks before the final milestone of the project (the event date). The other being that the task can only start once a prior task has…
Can you use an "IF" function with a dropdown?
I have a dropdown list in one column with 5 options to select. I want a Text/Number column to produce a designated value based on the option selected from the dropdown: Dropdown contains : Project, Small Project, etc. Values would be Project = 10, Small Project = 9 Every attempt tells me #UNPARSEABLE. What am I doing wrong?
Web form entry checked box cell value be what they checked, not a check mark
Once the sheet is populated from the form and exported into Excel, the check marks turn into true. I want to be able to either in smartsheet or excel share the row they put their entries in with them.
Formula to change a cell's value if date is in the past and another column's value is not a certain
Hello there, this is my first discussion and I have a feeling this might not be possible, hehe. I would like the Status (a dropdown list column) to change to a certain value ("Complete") if the Date (a date column) is in the past and the Type (a dropdown list) is not a certain value ("On Campus"). Thank you so much!