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
Setting Milestones
I want to set the end date, and have my project manager set the duration which will in turn change the start date. Is this possible?
Durations
Hi - My durations are not adding up. Help!
HR Templates from Website not recognising existing user
Hi team, This is a little odd, maybe I am missign seomthing very simple? I am logged in to SS I am here: https://www.smartsheet.com/top-excel-templates-human-resources I click on 'Create you XXXXX in Smartsheet' It asks me to sign up as a trial member, even though I am logged in. The template II'd like to view I cannot…
date range formulas
Can anyone help me please with the below formula. it all works fine except the date section at the end. what i am trying to achieve is a condition that captures entries that fall between 2 dates in the past. eg last 60 days and last 30 days =SUMIFS([Actual Hours]43:[Actual Hours]602, Status43:Status602, "Complete",…
New Comment Format Causing Confusion
We have been using the old Discussions feature for the last 3+ years as a way of entering unrelated notes on projects rather than as a way to send messages back and forth between users. The recent transition to Comments has made all our notes look like replies to previous notes when in fact they are totally unrelated. To…
How do I collapse the discussion threads?
One of the features we really liked before was the ability to collapse message threads based upon certain topics. This new version of discussion threads doesn’t appear to allow for that. Is there any way of reverting back to the classic view? Or is this not possible? It was nice having the titles of the discussion threads…
Self-populating formulas in rows
Why don't the formulas instantly populate the next row? This is extremely frustrating. Sometimes, the self-population or smart population of formulas will occur in proceeding rows, and the other times, it won't. Is there some sort of trick or process to make sure this happens every time? Thanks in advance for any help with…
Sights Help
I would like to add a widget in sights like the "Complete" widget in this example. I can bring in the number and % in a report, but how can I bring in the symbol and definition? Thank you!
Time Tracking and Invoicing Clients
I'm trying to find the best way to track time against projects using smart sheets in a way that billable time can be easily invoiced. Ive read through many community posts, but still cannot find something that is helpful, or a smart sheet template that I think will work wel. We currently use Zoho Projects for time entry.…
Yesterday's Completed Task Formula
I am looking for a way to capture the number of taks that were completed yesterday. I started by using a report however yesterday or last working day were not an option. I tried using in the last days - and used 1 however when yesterday is a weekend is skews the data. I then tried using a COUNTIFS formula but I run into…
