-
Can I sum two cells together and then clear the contents of one cell without changing new total?
I have two cells that I would like to sum together based on a check box. When Order Received is checked, Quantity Delivered is then sent into my total inventory in row 1. I would then like to clear all of the contents of row 2 through an automation, because that order is complete and done with, without changing my new…
-
Help with WEEKNUMBER formula
Hi, I need a column to show the week number of the year. When I try the simple =weeknumber(TimeCardEntryDate@row) formula, it doesn't seem correct, but I've seen other posts about how Smartsheet calculates week numbers uniquely. I need the weeks to count from Sunday-Saturday. So, in the picture below, 12/31/23-1/6/24…
-
How to replace an SOP in a row when that row is updated
Hi everyone! I am creating an SOP Tracking system for my company where I will track all SOP’s being created. That being said, I need to be able to replace an SOP when the SOP is updated. Can I do this using either forms or automation? The SOP will have a specific name associated with it that will be able to be matched when…
-
Why is this formula #invalid operation
=COUNTIFS(Flight:Flight, "FSC", [Date of Award]:[Date of Award], >1 / 1 / 2023, [Date of Award]:[Date of Award], <3 / 30 / 2023) If I put the dates in parenthesizes it yeilds 0 even though I have "FSC" in the Flight column. If I take them away it becomes #invalid.
-
Help with CountIFs formula
Hello, I am trying to use the CountIFs formula to calculate the number of times each category in a drop down list appears in one column. I'd also like to be able to make sure the items are only being counted are in Hierarchy level 2. Below is the list of categories, can anyone please help me understand writing the formula?…
-
Formula that counts # of incidents across a date range
I have a sheet for all incidents in the company that was started in 2023 and now that we're in 2024 I need to update some formulas so it only pulls the data for the current year. Right now the formula is =COUNTIFS({Incident Type}, [Primary Column]@row) but this doesn't take the date range into consideration. What should…
-
Using Formula for a total count/sum
Thank you for taking my question. What is the format to create a formula that supports this scenario; A total count or sum based on a specific word in a cell in a sheet. For example, collect the total number of the word "Pass". Same for "Fail" and so on.
-
Creating a formula to calculate percent from the parent rows
I am trying to create a formula for a cell where it collects the percentage of all the % values in the parent rows below it. Not only the current parent rows, but also any new ones that are added. The parent rows are currently averaging the percent in the sub rows below it. In this case, I want the total percent to be in…
-
Can you combine the criteria of formulas?
Hi, I'm looking to input a formula to a sheet which will count the number of "Open" residual risks that are also recognised as 16 and above. I already have a column for the number of Residual Risks scored 16 and above and a separate column counting the total number of open risks on the entire sheet. Is there a way to make…
-
Returning Non Duplicates when comparing two Multi-Select Columns
Dear Community Is this possible in Smartsheet? I just can't seem to return what I need! I've been playing with Join(Collect()) type statements but maybe I have overcomplicated it! Scenario and requirements are explained in the screen shot. Happy for you to say Column 1, Column 2 and Column 3 in any suggested formula, as my…
