-
Using the Greater/Lesser than with %'s
I'm trying to build a formula for 3 separate columns where it generates a number on whether the % provided is below or above a certain threshold: Unauthorized Return Rates < 0.5% Administrative Return Rates < 3.0% In my current formula it should say if the % is greater than 0.5%, it should list "1", and if less than 0.5%…
-
Trying to combine 2 AND functions with an OR
Hi There! I am new to SmartSheets and am working on a way to automate a process using the OR with AND's and running into trouble. Basically, I am trying to check a box in a column if any of the following is true. If the Model type is 1 AND the version is less than 9 OR If the model is 2 AND the version is less that 18…
-
IFERROR Formula Not Working
Good day, team. I have a formula that works as intended, which takes the latest row of children data and inputs that as the value. That formula is: =(INDEX(CHILDREN(), COUNT(CHILDREN()))) and produces the following results: However, if there is no data in the children cells it gives me an "Invalid Column Value" as shown…
-
Formula for excluding weekends for an end date
I have searched and attempted the WORKDAY formula without success. I have a schedule that populates from this source and we have columns as shown. to get the Est Finish Date i used formula =[Planned Install Date]@row + [Total Man Days]@row This worked great except we dont work weekends and i would prefer if we can show the…
-
Help with a SUMIF / TODAY Formula
Hi! I am trying to write a SUMIF formula that calculates four separate column values that is less than 7 days old. The below formula works, but I need to figure out how to add in the 3 other columns I need to include in the calculation. Column names: Motion Temp Total, Still Perm Total, Still Temp Total Any help would be…
-
Sum of child rows multiplied by other row.
Hello Community, Can the sum of child rows that are individually multiplied be achieved without the use of a helper column? I would like to be able to detail the total sum of the child rows [March 2025] multiplied by [Rate] without the use of a helper column. I =SUM(CHILDREN([March 2025]@row ) * CHILDREN(Rate@row ))…
-
SUMIFS Formula with Dates
Having some issues with a formula to gather project budget metric data. I want to sum the values between a date range for each project. I get the invalid operation error on the formula: =SUMIFS({Cost}, [Primary Column]@row = {PrjNm}, {Date} < DATE(2024, 12, 31))
-
Formula for counting rows as they flow in and out
Hi Everyone, We have an intake sheet, fed by a form, that assigns rows to staff members. Leadership wants to be able to balance workload by tracking numbers of rows assigned over a timeframe. On a metric sheet, we use =COUNTIFS({Column Name}, "Person Name") to see how many each person has assigned to them at any given…
-
Countifs
OK - So I have a multi select cell with 4 choices (A B C D). I need to count only the cells that contain only both A & D. I tried countifs using and, contains but cant quite eliminate the counting of other combos for exampe ( A B D). Thanks in advance for any ideas.
-
Convert Created Date to Month/Date using Local Time
We have a "Audit date" column which collects the date and time when a row is added. That currently comes through as "6/30/25 5:15 PM". We have a formula that labels a Month / Year for reporting based on the "Created Date" column. That formula currently is =YEAR([Audit Date]@row ) + " / " + MONTH([Audit Date]@row ) This has…