-
Weekly progress report - project related
Hi , Need a help of team. complex one :- I have Project Plan sheet for following data below screenshot 1 I want to create a report based on status and weekly progress % Complete as shown in Screen 2 to create a dashboard chart as shown in 3 to show it in dashboard.. Can you help me on it. Also, this weekly progress report…
-
Prevent Column Width Changing
Is there a way to prevent editors of a sheet to not adjust column widths? I have all of the columns locked, but I still find column widths adjusted, when I, as the admin/owner, do not want them adjusted.
-
Date Regenerating
Hello, is there a way to have information associated with a date to regenerate Every so often? For Example, we have a sheet that has an expiration date "Designation Expiration" and all the information after that is related to falling within that time period. We would like to have all of that information repopulate Every…
-
automate a download of a sheet
Dear Community: Please be gentle...I am new to the community. Our application uses forms to have people add row to various sheets. On one of the sheets we need to upload to one of 1000 systems as people continue to add to the sheets. I thought I could create a rule or action that would allow me to automatically download…
-
System generated Created (Date) column keeps changing itself to regular Date column.
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I save and re-fresh and it stays for awhile. I've moved around and added and deleted…
-
Printing Sheet Summary
Hi Is it, will it be possible to print the 'Sheet Summary' panel or export to PDF etc? Thanks Cheers Richard
-
Report Grouping Work Around
I have a list of SOPs and their supporting documents (Forms, Logs etc). As you can see in the Excel example, we have the SOPs in Green and the supported docs below. Some, like the SOP Training/Retraining Record, are used for multiple SOPs. I tried: Using Gantt functions, added a Predecessor Column but I couldn't run a…
-
Using IF, FUNCTIONS (HAS, CONTAINS, etc.), and OR (for searched fields).
Greetings Team, I feel like I'm missing something simple on this one, but it's a general problem that I encounter a lot. For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, and…
-
Do we have an update on Proofs being available in Reports?
Hello, My teams love having personalized reports but the function that we need the most is Proofing. Would there be an estimated time of when that the Proofing Function will be available in reports? Thank you, Johnathon S.
-
Schedule of Values
Has anyone created a sheet for Schedule of Values? Ultimately I am wanting to insert the project budget and tag the budget lines to the SOV lines. I can then go through and identify percent complete on the budget areas or on the SOV and it shows expected expenditures/profit. The best is if I have the budget and connect it…