Formulas and Functions
Archives for November 2021
Discussion List
-
Flag DuplicateIn Formulas and FunctionsHi 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 …Answered - Pending Review 40 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Autofill and then HardcodeIn Formulas and FunctionsHello, 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?…
-
Workday Function Counting Holidays on Another SheetIn Formulas and FunctionsTrying 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 ide…
-
How do i make a formula that references the first child row?In Formulas and Functionsi 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…
-
How to combine two IF formulas into one formulaIn Formulas and FunctionsHey 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…
-
Need assistance with adjusting formula to allow for 0 duration milestones in my Auto Health formula.In Formulas and FunctionsHi - 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 …Answered - Pending Review 24 views 3 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Need a Formula that only applies to Parent rowsIn Formulas and FunctionsI 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 f…Answered - Pending Review 126 views 12 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Formula to show Current Status of Project ApprovalIn Formulas and FunctionsNot 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…
-
Formula to return a date that always lands on WednesdayIn Formulas and FunctionsHi, 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)&l…Answered - Pending Review 14 views 3 comments 0 points Most recent by bcassidy33 Formulas and Functions
-
Add a ranking listIn Formulas and FunctionsHello, 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.Answered - Pending Review 139 views 5 comments 0 points Most recent by Genevieve P. Formulas and Functions