-
Quote Request to Multiple Suppliers
Hello, I am looking at finding a way to send a quote request to a chosen list of suppliers. Is there any way I can send a row with all of the quote information to multiple email addresses where it will create a new row for each quote returned? I can then review the prices before choosing which supplier to proceed with. Any…
-
Skype Log in issue
When I try to sign in to Skype for Business, there will be a pop up for the sign in, but it quickly goes away and tries to do it all over again. I am using Google Chrome, and there are a few more people in our office having similar issues
-
Access (visibility and the option to edit) to SOME rows in a sheet
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal team has access to this sheet. One of the departments however, requires visibility of their related tasks, therefore I have…
-
Reports: Sorting groups of rows by the end dates of their respective master rows
Hello! I am hopeful that I can find the solution to this issue. This is a bit of a long one, so get comfortable! I am using SS to organize the workflow of active jobs at our precision manufacturing facility. Each job requires almost 100 independent job steps from start to finish. Each individual job task is on a separate…
-
Smartsheet's Error in % Complete Rollup
Hi, I recently realized that Smartsheet has a major flaw in rolling up % Completion. In Smartsheet %complete for a Parent is calculated as a weighted average of %completion of the immediate children times the duration of the Parent. For example in the following Project, the overall % complete shows 50% where the correct %…
-
Manpower Tracking with Projects
I am trying to set up a way to track manpower 50+ people plus projects that are ongoing. 2 separate sheets are fine - 1 project summary and 1 manpower. How can i set it up, that i can see who is available, when workers will be on vacation and it will notify is someone is booked for one project so i can't double book them.…
-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Automatically archive info to new sheet once hit limit .. ?
Hello there, Was hoping someone could have some insight on this. We are looking to see if smartsheets can be the platform for an operators log.. the features of the dashboard and filters to help ease searching ... But our issue is; the size constraints .. we probably would use 5000 lines in a few weeks and to manually…
-
Add a New Task with all the sub rows
I have a sheet where I have all my projects and then sub categories indented underneath it. Is there a way I can easily add a new project that will create automatically add the sub categories?
-
Grouping and Sorting
Hello, Coming from a project planning background I am used to being able to chose how I group my plans. Is it possible in smartsheet to group say by who a task is assigned too? I understand the way the indent function works and the way you can filter on "Assigned Too" if I wanted, but for eg I might want to view my full…