-
Conditional formatting for past dates dependent on other past dates
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.…
-
Counting Characters for Twitter
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
-
Conditional Formatting Question
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…
-
Primary Rows
How do I create a new primary row in SS? One that carries sub heads and rolls up to the calendar?
-
Help with Status and Date Columns
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…
-
Web Form Layout
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.
-
Calendar for Media Planning
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…
-
Conditional exclusion of rows
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
-
Format date in project schedule to include day of week
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.
-
Recurring Task Lists
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.
