-
What is the best practice for changes in task order, dates and predecessors?
I work for a residential construction remodeling company and one of the things I use smart sheets for is keeping track of the jobs progress. Before we start a job I set durations and a predecessors for the tasks that will be involved in the project. The problems I am having are the order of the project will change and the…
-
Permissions for non-licensed users
Hi All - I have a Smartsheet license and built out a project plan in Smartsheet which I'll be sharing with my team members who are non-licensed users. They will have editor access either way. Does anyone know if they will be able to enter or change formulas in cells which I've created as the admin? Thanks for your help in…
-
NetworkDay formula condition question
I'm looking for guidance please and appreciate any input! I was able to get the NETWORKDAY formula to work by itself. However, I am now trying to put a condition to calculate NETWORDAY if the Project Status is not "Complete". Otherwise, I want it to display the Duration field. It's not erroring, just says the format is not…
-
Help with a status update build off dates.
I am working with a smart sheet and want to update the status column with a drop-down value, pulling from the Schedule Delta%, which is fed by the next two columns: the Schedule Delta (working days) and duration columns. This is the formula on the sheet when I took over a project. I don't know what to do with the #REF. I…
-
Send Automation emails to multiple people like we send emails in 'TO' and 'CC'
To enhance automated workflows that send email alerts to multiple recipients, it would be beneficial to offer the flexibility of choosing between sending individual emails (as currently supported by Smartsheet) or sending a consolidated group email, which is not currently available. Often, the email alerts in Smartsheet…
-
Print to PDF, not all pages of the report are visible???
Printing a PDF file from my dashboard. The PDF only shows the first 1 1/2 pages. The report is a total of 4 pages, but the other 2 1/2 pages are not visible. I've attempted to "refresh" change print settings, etc., and still not printing as desired. Please help.
-
Assistance w/ Average Formula
I have 2 columns. One is a calculated field that displays Business Days Open. I have another field that has 1 of 4 possible values. I want to calculate the average business days open by each of the 4 values. value 1 = (average of "Business Days Open") value 2 = (average of "Business Days Open") value 3 = (average of…
-
Alternate Approach to "Latest Comment"
Right now, the Latest Comment column pulls in the latest comment from the row comments/conversation. Would be nice to have the Latest Comment also be able to pull text from a column directly to the left or right of Latest Comment. Concept would be entering multiple comments over the course of several days, weeks, etc.,…
-
Set Time Zone for Created Date reflected in Dynamic View
Issue: The Created Date column converts to Universal Time Coordinated (UTC) when you include it in the View Display of a Dymanic View. When collecting data in real time, this creates incorrect data on daily reports as the UTC is 7 hours different than the Pacific Standard Time (PST) - pushing some entries to the following…
-
Alerting the person that submitted the form
When multiple individuals within the company will be submitting a form for approval, how can I have the submitter to be notified if something was approved or declined? There are two approval stages but I need the submitter to be aware of the final stage.