Hello, Is there a way to condtionally format dates in the past based on other dates in the past? For example, we are transitioning our project schedule from excel to smartsheet. We have dates in the past as shown below. In excel they are conditionally formatted to turn red if the Actual happened after the Current Target.…
Hello! I'm using a sheet to track my social media (Twitter only at this point) posts prior to adding them to Hootsuite. I'm trying to figure out a way to have a column that will incidate wheather or not a text column has too many characters (140) or not. Is this possible?? Thanks, Claire
We use a Project Timeline Template that tracks the progress of each individual project. There are a number of parent rows with child rows beneath. I've created a status column so that each task can reflect the current progress via a harvey ball. I would like the parent rows to reflect the overall current status based on…
How do I create a new primary row in SS? One that carries sub heads and rolls up to the calendar?
Hello, I am having trouble with a formula. I have 3 date columns, and 1 status column. I would like the status to change with the input of a date in the columns. Here is the reasoning for the question. I have "Ready Date", A "Start Date", and a "Complete Date". When a date is in the "Ready Date" column, I want the status…
In webforms I have to make each item a column that I want info to flow into. Can I make those column print inot a row later? A long row info from columns is too much.
We are looking for a calendar solution to keep track for our advertising placements. We place about 100 ads per month, in multiple publications and multiple sizes. We would like to be able to see the calendar as a list by publication, publish date, deadline and as a standard calendar view. I checked out the templates but…
I want to have a sheet where based on a condition like a checked box certain rows are or are not available. For example if CAPEX is not checked then the Capex task rows are not available to see. Is this possible
Hello, Is there a way to change the format of the date within a project schedule to include the day of the week? Right now the format is 5/13/15, where it'd be much easier to read & use if it was Wed 5/13/15. any help is appreciated.
Is it possible to set up a recurring task list so that when I check a task as "done" the due date automatically recalculates to the next due date? Ideally it would create a new task with the new due date that was not marked as done. Thx.