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 2016 Posts
Archives for August 2016
Discussion List
Conditional Formatting Key or Legend
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
Web Forms
Is there a way to change the font and colors of a web form?
How to run a project report without Sights?
Sights seem to be prohibitively expensive for a small team or small enterprise. I am trying to do my best to get by without them, which is very frustrating because not having a dashboard is pretty bad...so bad I think I won't renew going forward since competitors do a better job in my opinion. That said, has anyone found a…
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…
Folders in attachments
I have a client who wants to use Smartsheet as a central repository for all data pertaining to a tech kit install. My Client requires folder hierarchy in attachments on a row. They require this to have better visibility of attached files on a row. Each row is to have a details of a piece of tech kit installed with a…
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…
Integration With Survey Moneky?
Is there a way to export survey results from Survey Monkey directly to a SS sheet?
Sum cells in a column based on check box status?
I am currently using a SUMIF formula (which works as expected) to sum values in a column when a row contains specific text =SUMIF($[Activity]$29:$[Activity]$344, "Consultations", [FY 2016 YTD]29:[FY 2016 YTD]344) Now I want to add a check box column so I can an another clause to my SUMIF statement to sum only those rows I…
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
Earned Value Management
Please how do you calculate earned value with smartsheet? I have been looking at the videos but yet to find an answer.
