-
Flag Duplicate
Hi I have a smartsheet that is essentially setup like this: Start Date End Date Start Time End Time Equipment 10/01/2021 10/01/2021 08:00 10:00 Shovel #1 10/01/2021 10/02/2021 07:00 11:00 Shovel #1 How can I flag for duplicate of the equipment? Essentially, if a row is entered and the same Equipment is being used during…
-
Autofill and then Hardcode
Hello, everyone. New day, new question. I would like the values in row 1 to fill into row 2 if "Check to Fill Material Lots" is checked. Should be simple enough with =if([Check to Fill Material Lots]@row = true, [GSP-1]1), right? The problem is that after the values are in row 2, they must be hardcoded. Otherwise, whenever…
-
Workday Function Counting Holidays on Another Sheet
Trying to make a function where it counts holidays referenced on another sheet. The formula I am using is =WORKDAY([Test Out Date]@row, 30, {Reference Sheet Column Location}) and I am getting an "Invalid Data Type" error Any idea what I need to do? I dont want to include my holidays on the same sheet cause it messes up…
-
How do i make a formula that references the first child row?
i have a sheet where i'm trying to track recurring payments and give me and easy way to see the upcoming payments. currently the status column has a formula that turns yellow ahead of the payment due date to alert me that i need to start this process. The "Done" rows are there in case i need to look at historical records…
-
How to combine two IF formulas into one formula
Hey Smartsheet Community, I was able to get the info I wanted using three different formulas but I wanted to know if it was possible to make this work with one big formula? Formula 1 - Symbol Colors for Major Project Completion Status =IF(AND([*Dropdown-Single*]17 = "Major Project", [*Date*]6 < TODAY(-30), [*Text*]55 <…
-
Need assistance with adjusting formula to allow for 0 duration milestones in my Auto Health formula.
Hi - I am using the following formula to display the auto health of each row in my sheet. I now need to capture key milestones, which have a "0" duration and need to adjust my formula to allow for this. Currently, as you can see my formula is dividing by the duration and if it is "0", it is displaying the default (gray).…
-
Need a Formula that only applies to Parent rows
I am trying to figure out a formula that will only apply to parent rows. I want the Parent % complete to calculate on the total percentage of all child rows. The embedded formula depends on a duration, and I do not want that. The current formula I have is this: =IF((COUNT(CHILDREN(Primary@row)) > 0),AVG((CHILDREN([%…
-
Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow. We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on. For example, based off my attached…
-
Formula to return a date that always lands on Wednesday
Hi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)<=4,(4-WEEKDAY([Task Name]29))+([Task Name]29),(11-WEEKDAY([Task Name]29))+([Task…
-
Add a ranking list
Hello, I am new to this site and fairly new to Smartsheet. I would like to provide a list and have participants rank the list by providing 1,2,3 etc to indicate their preferences. Can anyone provide a formula for this please? Thank you.