-
How to create a formula that will send notifications to specific users
Hello, Im trying to create a column formula that when a user selects a certain field, the responses will automatically go to a specific person/responder and will notify them of a task that's awaiting their approval. For example: someone wants more information about a specific oncology drug, (the "therapeutic area" column).…
-
Help with Budget sheet, with different rates depending on hours
Good afternoon, I'm looking for help with my budget sheet. I need to calculate the project design cost using a rate, but when we have a change order the rate can be different. As an example for the first 50 hours I need to use the rate of $100, but then for the next 50 hours I need to use the rate of $110, and so on. I…
-
If(CountIf) Support
Hello - I am trying to count something if it meets the criteria and running into an Invalid operation error. What I want to do: If the priority in another sheet is NOT "N/A", Count the status in another sheet if it equals "New". I was trying to do this: =IF({Priority for AAG} = "N/A", =COUNTIF({Status Column} = [Helper…
-
SUM MULTIPLE VALUES IN A ROW BASED ON MULTIPLE CRITERIA
I am trying to sum the Total $ Amount of multiple items, when they meet the Account Code criteria of multiple values in a row (not the entire column). For example, in the first row, "TOTAL $ AMOUNT, 9810-420" should equal $550.00 and "TOTAL $ AMOUNT, 9810-430" should equal $100.00. The "Item... $ Amount" columns are…
-
How do you exclude a specific dropdown status from another sheet in a formula?
I have 2 sheets. One sheet (Requestors) is tied to a form for people to get information about a possible coach. Through this awesome community, I've been able to figure out how to pull the information I need from the 2nd sheet (Coaches list), and display it in an automated email to the requestor (with a line break between…
-
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:…
-
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…