-
CELL LINKING
I AM USING SMARTSHEET TO HANDLE MY BUSINESS, ie: TRAVEL AGENCY. I WANT A WAY BY WHICH ALL MY DRIVERS CAN UPLOAD ABOUT THEIR AVAILABILITY AND THEN ALL THESE THINGS COME DIRECTLY TO MY SHEET. AND THE DRIVERS SHOULDNT BE ALLOWED TO VIEW MY SHEET, FOR THAT I THOUGHT OF CREATING A SEPERATE SHEET FOR EACH AND EVERY DRIVER AND…
-
SS Governance
Has anyone established best practices / governance for Project Managers and team members using SS that can be shared with me? The types of projects we use SS for are IT and Facilities related. Thank you.
-
IF statement help to determine active sprint
Hi all -- just starting to build a library of IF statements... Looking for some help to build an IF statement to determine which Sprint is the current active sprint... Basically, IF Today's date is between [ColumnSprintStartDate] and [ColumnSprintEndDate] then check the box, if the date is not between those, then leave it…
-
Question about sorting
Hi, i'm looking for some suggestions on an issue that I am seeing related to sorting in one of my Smartsheets. I have a sheet that has a row with instructions to the users as the first row. I have a checkbox column that is only checked off in the instruction row, and I use a sort to keep this at the top of the sheet. My…
-
Suggestion: The Metric Widget should count items in a column
For example, if I have a dropdown of all 50 states, I should be able to set up a widget to count the number of times Alaska was selected, simply by selecting that column and one of the selectable options. If 20 people have selected Alaska, it would read 20. When a 21st person selects Alaska, then that widget would read 21.…
-
Here we go!! Ready to roll out our BETA project plan!
After a couple of weeks learning Smartsheets and simplifying our project plan, we are ready to beta test our PM Lite template. https://app.smartsheet.com/b/publish?EQBCT=f5644ec0fe854b2b9c3bf74084bf86d7 It's still pretty rough but with a group not use to a formal PM process it should get us started on the right track.…
-
Sheet to sheet selective data transfer (for new rows)
I currently have two active sheets. The first sheet, we'll call "intake" and the latter "Projects". If I review a *new* row added to "intake" and determine I want to copy it over to "Projects", I need selective data from certain columns on that sheet to transfer to certain columns on "Projects". The columns do not directly…
-
Smartsheet Team Plan Offline and No Response from Support
Last week we cancelled a recurring PayPal payment approval on the PayPal site, so that we could register a different card as our preferred SmartSheet payment method for our annual plan. Although we didn't make any changes on the Smartsheet website itself, our Team Plan instantly disappeared and all Users were downgraded to…
-
Is there a formula for averaging the remaining?
Hello again! I have been trying to figure out a formula for averaging the remaining. This sheet has all business days through Dec 8 and a certain number of tasks to complete each day to be finished on time (Dec. 8). There are two columns. One has the number of tasks due to be completed each day (labeled Average) and the…
-
Approval set up
I'm trying to set up approval emails to go to specific department leads after another box has been checked as reviewed. Process: 1.) I apply for a position. I select my position from a dropdown, say "IT". 2.) HR gets an approval email. They review my application and click approve. 3.) An email is automated to the IT…