Formulas
Discussion List
-
Formula for Max Value and Row NameIn Formulas and FunctionsHello - I am trying to pull in the max value of column A and the name(s) associated with that value. I am trying to use the following formula to pull in the max value and taking into consideration there could be multiples of the max value…
-
Creating a custom number formula with conditionsIn Formulas and FunctionsHello! I am trying to create a formula in which a row is automatically assigned the next number in a series if the progress column blank, "Not started," "Processing," or "Equipment checked out." If the progres…
-
Countif Help Getting #Invalid OperationIn Formulas and FunctionsI have two columns of data. In one column I have a formula that looks for Ownership Changes (=COUNTIF([Service Request Record Type]:[Service Request Record Type], "Ownership Changes") In another column I have a formula that is l…Answered - Pending Review 8 views 2 comments 0 points Most recent by Christopher Pretty Formulas and Functions
-
#DIVIDE BY ZERO ErrorIn Formulas and FunctionsHello - I get this #DIVIDE BY ZERO error when I try to take the average on multiple criterias. Here is my formula: =AVG(COLLECT([Target Date Variance]:[Target Date Variance], [Design Team]:[Design Team], "Experience Design", [D…
-
How can I average two count totals on reports?In Formulas and FunctionsHello! I have two reports: Report 1 has the total count of tasks. Report 2 has the total count of sub-tasks. How can I automatically calculate the average number of subtasks per task (number of sub-tasks/number of tasks) from these reports…
-
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…
-
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 18 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?In Formulas and FunctionsHard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type…Answered - Pending Review 11 views 3 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Percent complete when using date & checkbox field typesIn Using SmartsheetI have a task sheet that lists 7 items per row that need to be completed. I would like to calculate the percent complete of these tasks, but am running into trouble with my formula. I have 4 checkbox columns, and 3 date columns. I may not …
-
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…
