-
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…
-
Including only the most recent comment.
Hi there, Within the "Print Setup" for .pdf reports, under "Options", "Include comments" checkbox....when selecting this checkbox it prints out the full set of comments which is fantastic but can make the report quite lengthy, especially over time. However is there a way, or is it possible in future upgrades to select an…