-
Total sum of results of a formula?
I have a formula to calculate payouts as follows: =IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 75000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <= 250000), "$2500", IF(AND([Estimated New Annual (ACV) Net Booking $ Amount]@row >= 251000, [Estimated New Annual (ACV) Net Booking $ Amount]@row <…
-
Red Flag for Overdue Tasks, without also Flagging non-dated ones
We are trying to use a formula to do the following: •tasks that have been cancelled are gray •tasks that are past their due date are red •tasks whose due dates come up within the next 5 days and are not yet complete are in Yellow •tasks which are already completed or whose start date hasn't hit, and are due in 14 days are…
-
Combined IF, AND, & OR Statments
I am having trouble with a combined IF, AND, & OR formula. The formula is to check five columns for a Yes "Y" value. For two of the columns only one value has to be Yes. If all are true then return a 1, if not then return a 0. Where is my formatting wrong? =IF(AND([SPC Received]@row = "Y", OR([SDS Received]@row = "Y",…
-
Formula to create symbols based on parameters
Hello Community, I'm attempting to create a formula that will create a green, red, or yellow dot symbol based on parameters and values within given cells. The formula I have thus far is below but I continue to receive error messages Any help would be appreciated. Thanks!
-
COUNTIFS across columns with multiple options for one column
I am trying to write a formula to count the number of columns across five nonadjacent columns that contain "Verified". The fifth column may contain "N/A" and also needs to be counted. In the example, 5 should be the total count for both rows. I've tried adding multiple COUNTIFS, and it doesn't work. Thanks in advance for…
-
Creating Archive Files In Smartsheet
While rewriting my 2016 Smartsheet application that tracks all sorts of weekly and monthly data on projects and employee billable hours charges, I needed to be able to store those results in archive files for use by various sheets and reports that use that data. Automated workflows allow that data to be copied to another…
-
Quarterly Budget with SUMIF
Good Morning, I am trying to use the SUMIF function to pull data from another sheet. =SUMIFS({Budget Requests Range 1}, {Budget Requests Range 2}, "Software", {Q/Y Lookup}, [Q/Y]@row, "") The other content is: Budget Amount (Budget Requests Range 1) Type of Request (Budget Requests Range 2) Q/Y that the budget applies to…
-
Recent Submission Formula
Hello, My goal is to create a formula that will automatically update the current status of our utility systems based on the submission of the most recent inspection form. Basically, I'm looking to create a green dot on a separate sheet if ARU1 and ARU2 are both online and both temperatures are in spec (I can provide the…
-
Pulling most recent values from form submission
Hi Community, I'm attempting to pull a value from a cell based on the most recent form submission. The information I'm trying to pull is from the below: I'm looking for a formula to collect the value from from the "Visually Inspect ARU1 HMI/ verify systems in auto" column based on the most recent submission (Row 1). I've…
-
Getting Message Column Formula Syntax Isn't Right
Hello, I have the formula below that works, but when I try to "convert to a column formula", I get the error. Does anyone have any ideas why? Thank you! =IF([Date & Time]@row = $[Date & Time]$2, "8:30 AM - 9:45 AM", IF([Date & Time]@row = $[Date & Time]$3, "3:30 PM - 4:45 PM"))