-
Predecessors - Either/Or
Is there a way to make predecessors either/or? For example, I have my task on row 3 tied to tasks on rows 1 and 2. But in my project, both tasks 1 & 2 aren't required, they are an either/or kind of task. So I want my predecessors to be set up that task 3 will start when either task 1 OR 2 have been complete. Is there a way…
-
Status Change if Column Checked
Hi everyone, I need some help with a formula that just doesn't want to work for me. Currently my status column changes according to the {Proof Approval - Kim} column. It works fine (formula shown below) Now I want to add on to this formula so, if the column {Out For Approval} is checked, I want the status to change from…
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
If a date is within 7 days of todays date
Hi I am trying to create a formula to hight light a cell if the date it contains is within 7 days (prior) to todays date... Can anyone help, I have this working on a spreadsheet but cannot seem to get it working on smartsheet. Thank you
-
Adding Task Name to Right Side of Bars
I have an existing sheet that used from a template. It was imported from Project. There are currently no task names beside the bars in the Gantt chart. Is there a way to add the task name to show up to the right of the bars in the Gantt view?
-
Flag if Multiple Dates in Same Column
I'm attempting to set up conditional formatting to highlight cells if there are duplicate dates in the same column. (For a spreadsheet managing event bookings, want to highlight if multiple requests for same day) I tried an IF/COUNTIF function in a new checkbox column but I keep getting #UNPARSEABLE. - Column name is Mtg…
-
Apply text formatting to tasks in card view
I would like to be able to, essentially, apply multiple conditions to rows and be able to see them in card view. Currently, I have a condition that changes the task bar color based on a dropdown column. I'd like to also have the ability to apply a text-related condtion (changing the text color to red if the due date is…
-
Date Calculation Question
Can anyone share with me on how I can calculate what I call the 'Next Quarter Projects'? For example: I have a start date and end date columns for each project, and I want to create a Filter/View that shows me the projects that are due in between a date range(ie Q2, Q3, Q4, etc) Can anyone help? Thanks!
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…