-
Change cell automation not working
I have an automation to change the value of one cell based on the value in another cell in the same sheet. The change is to occur when triggered. The source cell value is based on a VLOOKUP formula referencing another sheet. The cell with the VLOOKUP value changes based on the formula, but the automation to trigger a…
-
Count if formula to include multiple years
Hello, I am attempting to count all the submissions for 2023 and 2024 - my current formula only allows the dashboard to reflect the current year submissions based on my helper column for the year of submission. Does anyone know how to update the formula to count all submissions from 2023 AND 2024? Current equation:…
-
Working with Symbol Formulas
Hello Smartsheet Community! As our Community grows, I am starting to see some trends about features and workarounds users want to learn more about. For these topics, I am starting a new series of announcements. In this series, I will write about trending topics and topics that you request! After I post about a subject, I…
-
Sumifs That Excludes Parents
Hello, I am working on an ever expanding project timeline that has 100's of parent tasks that flow into potentially up to 10+ levels of parent tasks, with children tasks at every level. Given the granularity of the task management and the timeline being outwardly facing, "=sum(children())" is used on every parent task to…
-
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…
