-
Depending on the number of check boxes chosen add them.
I have 5 columns with Checkboxes and one with % Complete, I need the %column to show the values added up depending on the number of check boxes chosen, so if there are 3 checked boxes, it should show 60% complete. Can you help? Thanks See screen shot attached
-
Multiple Checkboxes give different Text values
Hi, ok I have 3 columns with Check boxes, each one with a separate word, "Pre-Screen, Development, Test. I want have these word values show up on the same row in a different column when I choose the Checkbox. I can get it to work for just 1 word on the row, how do I add the others in the formula so what ever checkbox is…
-
Auto pre-populate a web form
Good day, I would like to pre-populate a smartsheet form with values in certain columns. I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text. However, I want to avoid having to create each URL by hand, this will take forever. Is there a way to automatically generate the…
-
Enhancement Request - Hidden Columns Manager
Running out of screen real estate is a problem. I find myself hiding or dragging columns to right and then having to unhide them or drag them back into the active area of the screen as needed. Request for a utility that would store preferences for hidden columns that has the same general controls as the <filters> widget.…
-
Sheet Data Reports
Hello SmartSheet community! We've been using Smartsheet for a while now throughout our company and so far have several sheets. Some have important deadlines/dates while some just have to-do lists with several tasks that are flagged as important. I'm having difficulty figuring out how to compile all of the upcoming dates,…
-
More than one contact in the contact list drop-down
We have a column type "contact list" that we use to track sales reps for individual products. Sometimes we have a product with more than one sales rep. I created a group with both sales reps as part of the group thinking I could use the group as the contact. It isn't available in the dropdown, only individuals. I want to…
-
Include update request button on Alerts
Hello, Is there a way to include the update request on an email alert? We currently send our customers a notifications when they submit a request. What we would like to do is give the customer the ability to update the request without giving them access to the sheet. We also do not want to manually send an update request…
-
Moving Rows with a Formula
Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
-
Outlook Integration - Link Email Address To SmartSheet Contact
I'm using the Outlook integration for SmartSheet to update my task list I manage in SmartSheet. In my task list I have an "Assigned To" column, with a column type of "Contact List." While in Outlook, I can update the "Assigned To" field. If I type in the person's email address correctly, SmartSheet will notice the email,…
-
IF Statement Help
I have a sales price database with one column for a retail price and another for a sale price. I'd like to make a 3rd column with a formula that populates the Save __% for our Marketing team. I made this formula which works with one small issue I'd like to resolve if possible. =IFERROR(("Save " + (ROUND(1 - ([Sale…
