-
IF FIND RIGHT String
Hello, I’ve been searching all over the Smartsheet community since last week and was hoping someone could offer some assistance. I have a long Status value that I need to auto populate a shorter value in another column. I really just need a contains formula but I haven't seen that as an option here. I could do this for the…
-
Create charts without hidden data
Is it possible to create a chart without including the hidden data?
-
Help getting started
I am very new to smartsheet and am only day 3 of using the tool. I am looking for some guidance or confirmation in my approach to manage the projects of my team. I have about 53 team members and everyone has anywhere from 5-30 projects that are either being actively working on or are in the pipeline. I am looking for the…
-
Risk Status on my Smartsheet using formulas
I am using Blue, Green, Yellow and Red for my project status - I have a formula around it that will change the color accordingly. What I want to do is if the color ever turns Yellow or Red log it as a risk in another column. I can get it to work but if it is ever a risk I want it to remain a risk even if the task turns…
-
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…