-
Supplier Order Management
Hi, i have signed up for the trail version to see if we can design a smartsheet for supplier order management. We are a small bookshop and our customers send us their orders via email and websites. We then check stocks in our warehouse if available we supply and if not then we inform "ORDERS DEPARTMENT". The Department…
-
CONSULTANT NEEDED FOR HELP- BASEL SWITZERLAND
Hello, we are a federation (www.ipaf.org) we need some help to set up a project for the launch of our new eLearning system. We will need the help of an expert in project management and use of smart sheet. It's probably just a couple of days of work. The consultancy work can be done in person in our offices in Basel or…
-
Recurring Milestones in Gantt Chart
Hi - I'd like to create a recurring milestone in a gantt chart. Do I need to create multiple activities on the list view or is there a formula that will generate a recurrence for a single activity? Thanks!
-
Color coding based on multiple columns
Hi, I have a sheet that includes Start Date, Finish Date and Status Columns. I'd like to create an IF formula that considers data in all three columns in order to create color coded balls as shown here (https://www.smartsheet.com/blog/support-tip-automate-RYG-balls). Specifically, I'd like the logic to be: If Start is…
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Privacy Policy
I have serious problems with delivery of Smartsheet based Web site solution becouse of Smartsheet Privacy Policy sign on Web Form, which is in conflict with our Privacy Policy. Any solution to hide it? s there a guideline available how to prepare our own forms for Smarsheet, if we can not resolve above problem.
-
How do I use an OR function with a simple IF function?
I’m currently using this simple IF function (If Team Column equals “Undergraduate Robing”, check the box (formula below) but I need the box checked if the team column equals “Undergraduate Robing" or “Faculty Robing” or “Marshals”. Is this possible? Current Formula: =IF(Team1 = "Undergraduate Robing", 1, 0) Any assistance…
-
Finding the most recent date for one person
I work at an University and we are trying out smartsheet for keeping a log of when instructors have taught. In one sheet I have a column for the start date of the course, the end date, the name of the course and the instructors name. I am wondering if there is a way to pull the most recent date that an instructor has…
-
General Plea for Openness
I would like to ask community members to add some details into thier profiles so that we all can get a better understanding of who you are, what industry you work in etc. The comunity is about sharing, helping and working together and this is much nicer when you know a little about who is asking for the help or guidence.…
-
Is there a way to get the autonumbered Row ID to display in the web form that feeds my smartsheet?
It appears that system columns cannot be added to a web form. I need a way to assign a number to each submission that the submitter can see in the email that is sent back to them.
