-
Flagging a Date and Time Overlap Across Multiple Days
Hi all, I need some help with a formula which I believe I almost crack but I don't know what I'm still missing here, I want to flag overlapping tasks across multiple days and times, as you can see below, I have different columns: Start date, end date, start time, end time. Start and finish are just switching the time…
-
How can I use one sheet to build onto another and still be able to manipulate the data?
I am pretty new to Smartsheet, and my office would like to account for requests using Smartsheet. There are two types of requests: Original and Supplemental. Supplemental requests build onto original requests. Therefore, if someone wants to request the same individual, they will submit a supplemental request because an…
-
Sort Order of Columns with Dropdown List -- Feature Request
Please consider offering more flexibility in the Sort functionality for columns with dropdown lists. I appreciate the column sort order following the dropdown list's order. But, it is missing a couple things. Allow the user to optionally select this behavior vs. sort on the actual alpha-numeric value in the column…
-
Help with COUNTIFS and CHILDREN Function
Hello! I am trying to get a formula to, automatically update status colors for the child and parent. The Parent is distinguished by "Main Project" in the "Project or Task" Column. I would like the Parent Row to update to show the worst status that aligns to the children status (i.e. if all children are green, parent is…
-
How to look across columns with checkbox data type to make them mutually exclusive?
I have 3 columns in my Project Plan that I am using to have team members fill in to indicate if their task is off track, on track, or complete. I only want them to be able to check one of the boxes. Is there a way to look across these 3 columns in a row to meet the following conditions: If Off track is checked, clear…
-
Finish Date Static vs Duration Static
Can the Finish date be static and have the start date and duration dynamic? Example: I have Task 1 and Task 2. Task 1 has a duration of 5 days and Task 2 has a duration of 10 days. Task 2 has a dependency on Task 1. But Task 2 has a due date that cannot change. If Task 1 goes over the 5 days by one day, I update the…
-
Formula/Function to pull new rows/updated rows to another sheet
Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our Week 0 deadline. Since the source sheet is constantly being updated and new issues are added weekly, I want my sheet to be…
-
How do I get the Credly badge to display on my profile?
I got Core Product Certified about a month ago at ENGAGE. However, I did not receive an email with a Credly badge like I did for the Core App self paced learning. I also haven't received the badge here on Smartsheet Community. I'm not sure if this is an issue because I took the certification exam in person, but I'd love to…
-
Filter rows under parent row?
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue is submitted via the form for a High Priority. Have it automatically sort under the High Priority Parent Row? As of right…
-
Total Age tracker overwrites last modified
Hi all, Hoping someone out there can help and hoping its just something simple i need to change. We use Smart sheets to monitor cases by age outstanding to help prioritise what needs looking at first. so i have a formula to grab data from a cell says A1 that has the TODAY function in. and then take that away from the last…