-
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
-
One stop shop for Project Managers
We use SharePoint for our project information, forms, and such and we use Smartsheet for our project schedules. I would like to be able to link the log in page in SharePoint so when my PM's click on the Smartsheet button in SharePoint that they are provided with the login screen to Smartsheet and get into their one or many…
-
Web Forms - The ability to Submit and Add New entry
We utilize Web Form option to track Support Cases. If a user has multiple cases, they currently have to submit their first case then go back into the URL for the Form to enter another case. Is it possible to have an option at the bottom of 'Submit and Add New', eliminating the need to go in and out of the form?
-
RYG Balls connected to Whether Items are completed or not.
I am looking to connected RYG balls to whether certain items are complete or not? I am not sure of the best way to do this- if a checkbox would be the way to connect color change based on status of task, or if inputting a "completion date" would do the same thing? I tried a couple of different formulas from these forums…
-
Alerts & Actions
I am trying to ultimately set up my sheet to automatically send out Update Request 3 days (or whatever I set) within the "Bid Date" loaded into the sheet. It would be ideal if this update request would be emailed to the contact in "Sales Rep" column and copy (cc) me in the emailed Update Request for all of them. I was told…
-
Dashboard
How can I create an A0 landscape dashboard canvas
-
IF WITH 2 CRITERIA
I'm looking to make a formula that will do the following: search all instances in Column2 for "A" IF subsequent Column3 has a value of "YES"....if all "A"s = "YES" than return a value of "YES" otherwise "NO" I included an image that hopefully clarifies this a little more. in the image I show 3 "A"s in Column2, 2=YES and…
-
Developing a Matrix Questionnaire
Hello, I am hoping someone can help me design this type of Survey Form to send out to my work employees. I would like to ask them to pick an answer (that I give them), by selecting the radio button. It seems easy enough however, I do not see this. I have attached a screenshot. If you know how to do this, I would really…
-
Cross-Sheet Project Status Rollup (Dashboard?)
Long time user, first time trying to do something cross-sheet. Lets say I have a folder called "Projects" and it contains all "Project Sheet" type sheets. Outside of the folder I'd like to have a sheet or a dashboard that dynamically looks at the sheets inside the folder, list out the sheet names with total % complete. Any…
-
Jira Smartsheet Workflows are not static
Not sure if I am expressing this correctly. However, my workflow I set up on Friday worked perfectly, but I noticed it was not updating when changes were made in Jira. When I go to edit to looked back at the workflow the Settings say under Jira project: Configure Jira Instance . However, it does show the proper Jira…
