-
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.
-
What is the "Created by" option supposed to do?
I have used this option for a System column thinking it would automatically populate the email or user name of the person (within my network) who submits a request by web form. However, all tests by several users of this functionality show the same "email address" - web-form@smartsheet.com when the request hits my…
-
Webforms
I have a sheet that I've already created and I only need non-smartsheet users to fill out the address column. Can I make my current sheet a webform and require them to enter data into an existing cell by selecting their names?
