-
Is there a way to select from a project schedule the next upcoming milestone?
Is there a way to select from a project schedule the next upcoming milestone. I have a flag column identifyng milestones and a column that calculates for just milestones the number of days between the task finish date and today's date and therfore the lowest value is the next upcoming milesone. I desire to pull the…
-
Contact List - Assigned to - automatic alert?
Hi guys, Is there a way to automatically 'alert' someone if they are 'assigned to' a task using a contact list column? Would love to hear a workaround if you have found one. Cheers
-
Continuously moving inventory - keeping a record without overwriting current information
Hi there, We have an existing Inventory database in Excel that i have imported successfully. However now I need to figure out - if I can - how to 'track' the movements of any given piece of equipment. For example we have a Computer Monitors that are 'loaned' to customers every so often. I woud like to keep a 'log' of the…
-
Updating Rows - by way of existing Webform
Hi all, So I have a simple sheet, webform attached which is working well with no issues. Rather than updating each individual cell ON THE SHEET, can I bring up the row's information as a webform (or something similar) in a way that shows the information in that row (filled in the appropriate places on the 'pop up'…
-
How to insert a disclaimer in the header
Our Smartsheets are already branded and using our logo in the top right corner. Our Legal Dept wants a visible disclaimer to be shown on each sheet that users cannot share any information on the sheet outside the company. I tried to put the disclaimer in the logo area, but you can't read it. What is the best way to show a…
-
Star Ratings/ Symbols - changing amount?
Hi, I have a sheet where we want to monitor the value of a project simply with a 1 to 3 star rating, but the only star symbols available are either an on/off, 1 star symbol, or a 0-5 star rating. Is there any way of reducing the mount of stars to simply 1-3, or is there a formula (similar to the RYG ball) to show this? I…
-
Once 'complete' can I move an entire row to another created sheet
Once a line item (row) is marked YES complete, can that entire row (with or without formatting) be moved to another sheet so that it is not shown on the in-progress/working sheet? Or... can I move an entire row within the sheet if a specific column is marked such as conditional formatting. Thanks
-
Holidays over multiple projects
Hello, Is there anyway to default dependences so that when you start a new project sheet the dependences are already set? I am currently setting up multiple projects and having to enter working weeks, hours per day and holidays is quite time consuming.
-
Shading alternate rows
Is it possible to define a default condition on sheets so alternating rows are shaded? This would improve our readability. Many people add to this sheet, so creating them manually is a major pain.
-
Adding Logo to Existing Sheets
I have tried to add a company logo to the existing sheet that I have created. I am unable to add it and it show up when printed to PDF. I added a workspace and then uploaded a logo and then added the sheet to the workspace thinking it would add the logo but that didnt work either. Is there a way to add a logo to existing…