-
How can I link two forms from two different sheets to put the answers on one singular sheet?
I want to be able to have two sheets with two different forms, but then I want the two forms to also have one sheet with the answers from both forms so that the answers are combined. Is that possible? If so, could you help?
-
Setting up billing rates in grid view?
As a newbie, I'm trying to set up billing rates in Grid View by job title, but I'm finding the help documentation in SmartSheet lacking (see attached screen shot). Is this even possible in Grid View? Or is Gantt View the only option? Or, is conditional formatting the only approach? Any input or ideas would be greatly…
-
Setting Formula using RYG
Hi! I'm trying to set up a formula using the Red, Yellow, Green symbols but I'm having difficulty doing so with how we use it. So basically, we have multiple columns we use to grade our employees in a QA setting so example Red=No, Yellow=Somewhat, Green=Yes. I am not even sure if this is possible. Any input advice how to…
-
NEED TO ADD LAST COMPLETION DATE IN COMPLETION DATE COLUMN
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the date of last row that changed to "complete" status. NOTE: The Record a date automated workflow…
-
Conditional formatting
Hi All, i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column
-
CHANGE ON SITE AFTER IS CONFIRMED
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status”…
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Formula to shift numbers in a column
I have a column called "Priority" that has my tasks (rows) ranked by importance, with 1 being the top priority and 10 being the lowest priority. When I check off a task I want to delete 1 from the most important task and have that 1 replace that task that is numbered "2". Is there a formula to do this? Something like if 1…
-
Smartsheet causes CPU usage spikes
I'm using Smartsheet in Google Chrome and notice that when it's left open for a period of time, Chrome is using a lot of CPU resource, to the point that the mouse won't move smoothly across the screen and typing is delayed appearing on screen. I don't think my Smartsheets are particularly complicated - the biggest is…
