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
$ per month formula
I am trying to put together a formula to track the amount of money we are bringing in per month per project. Not sure if I am doing it right... Any help would be appreicated. Here is what I am coming up with so far - =IF(Phase30)= "Construction", [Estimate $]30/Duration30) I know they duration is only calculated in days -…
Conditional formatting not always working on "Modified (Date)" column.
I have a status sheet that is picked up in a Sight. For ease of recognizing updates, I use condirional formatting to change the text color on items modified n the last few days. This worked well initially, but now the formatting is not always being applied. The same text column is updated all the time. Not sure what I may…
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.
Detailed timing?
Hi Folks. I see that there have been discussions for years about a feature that still seems to be missing. Even if now the duration of an event can be determined pretty detailed, we still can't tell that it is supposed to start at i.E. "9:15am next Tuesday"! Did I miss something, or is this feature really not yet…
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)?
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…
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…
Count "green balls" within a range
Hello I'm am wanting to count "green balls" within a range. I have used =COUNTIF([Site Attended]11:[Site Attended]26), "green") I'm have the result #unparsable I am a new user so would apprecate the help. Thank you
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!
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:…
