Formulas
Discussion List
-
Formula Question - Pulling in Multiple CriteriaIn Formulas and FunctionsI currently have a couple COUNTIFS formulas where I'm capturing the type by person by month as my criteria. I need to keep this criteria but add the condition that if multiple workers is selected in the source sheet (in a drop down with 3 …
-
Formula in metrics sheet to average numbers in column in source sheetIn Formulas and FunctionsI have a source sheet containing two date columns and a helper column containing a formula to calculate the network days between the date columns. (Example of several rows of my 600+ row source sheet.) In my metrics sheet, I want to calcu…Answered - Pending Review 17 views 3 comments 0 points Most recent by Jeff Reisman Formulas and Functions
-
Formula for difference in timeIn Formulas and FunctionsWe run events and are putting together the tech runsheet which has a column for: Time Start Time Finish Timer The timer column is what a speaker sees on their foldback monitor for how long they have left to present. I need this column to s…
-
Numerical "Priority" MethodIn Formulas and FunctionsHello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column …
-
Multiple IF and IF (AND) arguments in one formulaIn Formulas and FunctionsDoes anyone see any obvious issues with this string? I'm trying to pull from two columns [VA Feed status], [QA Feed status] and output one status based on the column statuses. This is a combination of IF(AND) and also just IF statements. …
-
Indicating a row is past dueIn Formulas and FunctionsHello everyone, I was wondering about a capability in Smartsheet. I was hoping to indicate a row was not completed on time. I am not talking about conditional formatting per say. I do not have a preference how this is shown but I was think…
-
How to Alter the "Sheet - IT Ticket Metrics"In Formulas and FunctionsI want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt…
-
Formula or conditional formatting for highlighting unique task namesIn Formulas and FunctionsHello Smartsheet Community, I wanted to "copy" condition made in excel into my Smartsheet, and can't get it done right. I would need to highlight unique title for the task, which doesn't exist in a different raw. I tried some dif…Answered - Pending Review 24 views 2 comments 0 points Most recent by Kamila Sroka Formulas and Functions
-
Collect record for previous day to Calculate varianceIn Formulas and FunctionsMain problem: I am attempting to collect the record of Daily absent for the previous day, I get incorrect argument error. I could use any help. My end goal is to use the previous day record against the daily absent record to get the varia…
-
Mid Date between 2 datesIn Formulas and FunctionsHello, Can anyone help me with a formula to find the mid date between 2 dates. Like what will be the mid date between 1st Jan 2021 and 31st March 2021.