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 DR…
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 y…
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 be…
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 c…
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 opti…
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=f5644ec0fe854b2b9c3bf74084bf86…
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…
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 di…
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…
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 "…