-
Move Incomplete Tasks
I'm a new user. There was a feature in MS Project that allowed the user to move incomplete parts of a task to the status date. This allowed the user to see how tasks that were behind schedule would affect the overall schedule and critical path. This could be done on a task by task basis or by slecting multiple tasks. How…
-
How to set calendar view permanently for a report
Hi, How can I set the calendar view permanently as a view for a report? And is it possible to display more on the calendar above the primary column?
-
How to set-up net-30 days in Smartsheet
Although seems very elementary to set this up, however, I am having the toughest time trying to build this "net-30" into our invoicing report. Can someone help me out? Thanks in advance!
-
Remove automatic references from title rows
I have set up an automatic reference column for a sheet . At the top of the sheet I have a two title rows. How to I remove the references from the title rows?
-
Can you reduce the depth of a row so only the 1st or 2nd rows of cell content are on view
-
Sharing and Limiting Report Information
Scenerio - I have a MASTER sheet that I am using to communicate with different contractors via individualized reports. The contractors are required to make updates to several fields. Once I assign a line or job to a contractor - it shows up on their individual report. Each line/job has contract specific details in the form…
-
Hiding data in my project plan for specific users
Hi, I read related smartsheet discussions on this. Is there a solution for this other than hiding the columns which contains the info you do not want to share with other users? I have budget figures on my project plan, and only 3/8 users are allowed to see it. I know you can create a seperate sheet and insert links. But…
-
Bar charts in tables using REPT function
I know SS is working on embedded charts for Sights but an easy workaround would be to have bar charts in a single cell using the Repeat function as in Excel. This is really a Text based formula cheat whereby a "|" is repeated by the value in question (i.e. =REPT("|",Ref) ). So, if you had a table and you wanted to rank the…
-
Percent Complete by Cell Color
Is there a formula to determine percent complete of a task based on the cell color? Cells are filled with dates of various steps in a project and once those are completed, the cell is highlighted. I'd like to have the percent complete column update automatically when the cell color is changed. Help, please!
-
Web Forms Client Input
I run a construction company and I require information from the client regarding decoration specification, colours etc. I have created a Smartsheet and need to get the client to fill out the information. Screenshot below What is the best way to get the information from the client ? Share the sheet? Only problem is I can’t…