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 January 2017
Discussion List
Tip / Tricks - Simplify Date Management w "Days from Today" calculation.
Looking at long column of dates is cognitively challenging, but everyone understands a range of numbers, negative to zero and then positive. I originally used this scheme to simplify my conditional formatting setup but found that users really liked it so now I keep it visible. It also makes reports much easier to…
Question about IF AND formula
Hello, I'm trying to use this formula on my smartsheet to create a column indicating "Late" if the phase is not closed and behind schedule, or "Missed" if the phase was approved, but after the target due date. It is coming back UNPARSEABLE. I apprecate any insight into what I'm doing wrong! Should I be using ISBLANK…
Listing unique values in a column, and counting them (group and sum)
I have to import a list of orders and count how many times each unique product was ordered. So the orders may list the same ITEM hundreds of times (eg: Item123 x10 pieces). I want another list or sheet which displays a UNIQUE list of each item, and a COUNT of how many pieces of that item was ordered. As my order list…
Question about reports
I have setup my smartsheet per project. I want to be able to run all my sheets individual for each specific project in the shop. My issue is with the reports though. Some of my group only need to see the ship date for a job in the calender format. Since i labeled the row i use for this number as ship dateand use the column…
Skype for Business Online Integration
My company is very interested in using the Skype for Business integration, but we have the on-premisis version of Skype. Is there any work-arounds or plans in the roadmap for the integration to be compatible with on-premises versions in the future?
Formulas are not copying to new entries for forms.
Every now and then, new form entries in my sheet will have some or all formulas missing. I add all new entries at the top of my sheets, so there are never any "blank" rows between that and the one below. I have an integration solution set up keying off of some of these formulas, so whenever they fail to copy, that gives me…
Editing the automated response email
How do I find/edit the autmated response email (sent whenever anyone submits an application). thx!
Drop down selection box legend
It would be really nice if when you set up a multiple choice slection box and you are using acronyms, that you could put a short description by each. I'm always trying to make columns narrower to allow more columns on the screen without having to use a slide bar to see more. I set up one column that indicates which…
Parent Relation on Progress %
Hi, i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates. I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be…
Conditional format using two columns
Hi, I have two columns Planned start and Actual start. I can't seem to set a conditional formatting rule when Planned start is not equal to Actual start. Please assist. Y