-
How to use a range of numbers in a formula
Hi SmartUsers, I have a formula to show bars according to the completion % of a cell. The formula is: =IF(Completed?9 = 1, "Full", IF([% Complete]9 = 0.25, "Quarter", IF([% Complete]9 = 0.5, "Half", IF([% Complete]9 = 0.75, "Three Quarter", IF([% Complete]9 = 1, "Full", "Empty"))))) It'll show 1 bar if a task is 25%, 2…
-
Recommended Master Project Document?
Is there a recommended method for tracking multiple projects? A master sheet or doc that shows the status or project of multiple projects? We've done some basic sheet linking but there was no status update and it was fairly manual. It would be great if there was a way to create a line item in the master project document…
-
Syncing Smartsheet Calendar with Google Calendar
Hi I would like to sync my smartsheet calendars with a google calendar so that I can have one centralised calendar for all of my sheets. However, when I sync them, I loose the conditional formatting (which I use to colour code the different types of tasks/appointments in smartsheet). How do I maintain the colour coding?…
-
Is there a way to add sheets to multiple reports at the same time?
Hi, I have set up a bunch of different reports across multiple sheets. These reports include 'Tasks Due Soon', 'Overdue Tasks', 'Tasks Assigned to X', etc... Many of the sheets we have created use the same template (Standard Project Template) so that they work consistently with reports, but some of our sheets have…
-
Conditional Formating between 2 dates
I know how to achieve this in excel but can't figure it out here. We are looking to highlight a cell (or row) if the number of business days between two cells is less than 3 business days For example in a row we have: Date1 = 11/30/15 Date2 = 12/2/15 In this case above we would want to color Date2 red (or the whole row)…
-
Account Settings/Working Days
Good morning, Just wondering if there's an upcoming enhancement for perhaps a drop-down box to select your country where it will auto-populate major holidays, such as New Year's Day, Christmas, Thanksgiving, etc, but also allow to add additional days, if needed. Blessings, Loann
-
I want to add sprint into my agile project plan
How do i add extra sprints?
-
Color Coding for Past Events
Hello! New Smartsheet user, and trying to figure out this awesome tool! Let me start with a basic question: So, we are using a Calendar of Events to help keep us on track for events that we have occuring here at our minor league ballpark. I'd like to be able to highlight events that have past already. I know in Excel it…
-
Gantt dependency Start/End Dates not populating?
I have a Gantt Chart with dependencies enabled. When I shift the entire start date of the project all the dates shift appropriately so I believe it's working well. I've just inserted a new row and assigned a Predecessor Row and Duration. The bar appears to the right and dependency lines are drawn. However the Start and End…
-
smartsheet realtime co-authoring
Can we work at the same time on different records.