-
Cell Time Stamp
Does anyone know if there is a way to get a Date to generate when a project is set to approved? I want to be able to set a target date using the time stamp from when a concept drawing is approved to when we will need to ship samples.
-
Possible to edit background colour in Calendar View?
Hi All. Here is my use case: we are using Smartsheet as our activity planning calendar for a team of dozen people. We have focus periods lasting from few weeks up to one month. We would like to communicate that e.g. May 1 to May 23 is time for Focus Area#1, and from May 24 to June 16 for Focus Area #2, and so on. Is there…
-
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…
