-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
-
Selecting the Next Task
This is a bit of a weird question but I'm trying to figure out how to make SmartSheet inform me what my next milestone is for a project. Basically I have a series of projects (say 40 or so) that each have their own project schedules. In those schedules, some tasks are marked with a checkbox to indicate they are critical…
-
cant add or hide column
I have the majority of functions greyed out. Screenshot attached. Any suggestions?
-
Find the Max and Min value in a column
Hi, I have a sheet with a single column that has a large range of numbers. I would like to use conditional formatting to highlight the highest number and the lowest number within this column so its easy to see when viewing the sheet. I can use the functions Max() and Min() to find the highest and lowest values, but these…
-
Conditional Formatting less than or equal to
I'm trying to setup conditional formatting so that when a cell has a value of less than or equal to zero, the cell will highlight. Unfortuantely, the is no 'less than or equal to' function. I tried to setup up two rules for less than zero and equal to zero but the problem is, the statements are linked by 'and' instead of…
-
Compare text in two different columns
I have a large SS that includes two rows of columns...one is the listing of the latest print revision, and I want to compare it to another column reporting which revision the part was actually built to. Both of these columns are populated with a letter (NC, A, B....AZ). My goal is a Conditional format color if the two…
-
JIRA Integration: automatically fill in "Start Date" when a Status has been changed?
Hi Smartsheet Community, We've integrated JIRA into Smartsheet. We're looking to automate some more fields. When using the gantt charts, some of the field we are manually filling are and Start Date and End Date. Is it possible to accomplish the following? 1) When a JIRA [Status] has been switched from To-Do --> In Progress…
-
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…
