-
Couple questions about Publishing to Google Cal
1. Which of the project partipants are Google cal's synched with? Can it be setup so it only synch's with specific person's calender that is assigned the task (and not project admins)? 2. Can a task be scheduled with specific times (or only entire days)?
-
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…
-
Typing stops when cursor is moved away from the cell
Recently I have noticed that in some of my sheets I am unable to type into cells once the mouse cursor is moved away from the cell. For example: 1. I double-click into a cell and can see the typing cursor flashing in it. 2. I type on the keyboard and see the text appearing as you'd expect. 3. Without clicking anything, I…
-
Save Templates to Workspace
How do i save a Template up to a Workspace?
-
Color coding based on multiple columns
Hi, I have a sheet that includes Start Date, Finish Date and Status Columns. I'd like to create an IF formula that considers data in all three columns in order to create color coded balls as shown here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls). Specifically, I'd like the logic to be: If Start is…
-
can i restrict data to dropdown menu only
can i restrict data to dropdown menu only
-
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…
-
Recover smart-sheet project plan from previously saved copies
the owner of a project plan has mistakenly deleted a great deal of lines in the master plan. my question is, can a smartsheet project plan be recovered from previous saved versions? greatly appreciate any feedback that can help to recover a recent copy of the plan Renato
-
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…
