-
Update Request Not Working as Planned
Hi there, I have an automation for my team's project sheet that sends an update request for every item that has a status other than 100% or "Not Supported." But it's sending update request for projects that are at 100%, which is both confusing and annoying for my teammates. Below are a couple of screenshots. Does anyone…
-
Formulas just won't formula :-(
for context - i would put myself as entry level for formulas in smartsheet. ChatGPT has been very helpful but clearly i'm doing something wrong. I've set up my managed references so it is pointing to the created date and satisfaction score. The forumals i'm using are looking at a range of created dates (month of july) and…
-
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…