-
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…
-
Auto-populating Job Numbers
I've had a query from one of our Smartsheet users who are looking to generate consecutive numbers when we they are building rows of jobs. I've advised him of the Auto Number/System column type, which would help with this. He then needs for all children rows to be auto generated an asset number. His query is as below: If we…
-
How can I change the set up of work days in worksheet app?
I've read the documentation of how to set up, but it's a PC version, does anyone know how to change the set up in worksheet app? I just want to change everyday to workdays, right now weekends are not available for putting plans on it.
-
% Allocation <100% in sheet not flowing to resource views
I have users assigned to tasks on projects at less than 100% eg 40% on one and 40% on another. However when I look on the resource view (for all projects) the individual shows as 200% (100% on the two projects). Anyone know why and what I need to do to resolve.
