-
Triggering a notification based on the dates of two rows
I would like to create a notification to let me know a task will be finishing late, which will impact the start of another. IF the 'Finish Date' of task 'Narrative' is greater than the "Start Date' of task 'Review' send notification You can see in the screen shot that Hillary is going to be impacted on starting her work…
-
Change next row status when previous row status is complete
I have multisteps to complete an order, Since start of many steps is dependant on the completion of previous steps, Can I program that if a previous steps say row 1 and 3 are complete (status Green), next row status changes to Yellow. I did this by giving code to each row and then with IF statement (If Code of row 1 and 3…
-
Automatically clear a flag symbol when a completed checkbox is selected.
Hi, I have created a simple workflow for testing a product. Within the row is a flag symbol column which the user selects to denote a fault. And when the fault is fixed a check box is selected at the end of the row to say it’s been completed. The fault flags throughout the sheet are counted in a running total as is the…
-
SUMIF with check mark
I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? =SUMIF([Have we paid for this container?]1:[Have we…
-
Automating RYG balls based on checkboxes
I'm trying to create a function to accomplsh the following: If coulumn 2 is checked, and column 3 is not checked, then the RYG ball in column 4 is green. If Column 2 is not checked, and column 3 is checked, then the RYG ball in column 4 is Red. When nothing in column 2 or 3 is checked, no RYG ball is displayed in column 4.…
-
Conditional formatting - specific for me?
As a new user, I need to get one thing clear: Is conditional formatting just seen by my user or is it seen by all users that has the sheet shared to them?
-
Parent Task Bar not updating based on conditional formating
I have a conditional format set to turn the task name bold/black and the task bar black if a checkbox is selected. The task bar does not turn black on Parent rows if the checkbox is selected. The task bar will turn black if the checkbox is selected for Children rows. Can this be fixed?
-
Automatically update related tasks when one date changes
Hi! My team is using Smartsheet for project management, and I want to know how to update due dates for tasks that are related. For example, if my original due date is 1/1/17, and there are several other tasks that are related to the starting date (edit, layout, print, etc.), if I change the date of one of those tasks, how…
-
Automating swim lane changes in Card View
Does anyone know of a way to automate moving a card/task that has been set to 100% complete in the % completion data field into the "Complete" column / swim lane in the Card View (or for that matter, automating any swim lane change in the Card View based on any task data parameter)? Currently it's a manual process of…
-
More column types?
Any chance we will see additional column formatting to include things like Currency and Phone number formatting?