-
Need help with a SUMIF formula to sum the number of credits with multiple AND and OR functions
This is a continuation of the question that was answered here: https://community.smartsheet.com/discussion/91230/need-help-calculating-number-of-credits-with-multiple-and-and-or-functions#latest The answerer found the correct formula! Results are in the screenshot below. I need help creating the correct formula syntax in a…
-
Countifs with Today Function
Hi! My team and I are having a hard time with some of our formulas. We need a count for how many projects that are ending in 30 days and as well as 90 days. Our currently formulas are not providing accurate numbers based off our what our filters are showing. Complete next 30 days formula: =COUNTIFS({HR Projects - Complete…
-
Syntax of an OR Statement inside a COUNTIFS
Hello, I have a formula that is working, but I need to add an OR statement in the priority so the function detects that the if the priority is "Critical" or "Blocker" it will be counted. Here is the formula below, can somebody please help me on where to add the OR statement? =COUNTIFS({Service Provider Name},…
-
Form Query String - Using Multiple Values
I've been doing some research on how to append values from a sheet, to a form link, so that when the user clicks on the link, certain fields are pre-populated. I've run into two issues that I'm looking for some help on: Can you add more than 2 values in the query string? I'm referencing fields in a sheet, so they're not…
-
% Time Elapsed Formula - Help breaking down and understanding long nested formula
Hi, I'd like help understanding the following formula that is being used in a sheet I inherited. I'd like to understand how to break down the formula to understand what exactly it is doing and how it is doing it. The formula is calculating "% Time Elapsed" based on Duration, Start Date and End Date.…
-
Heavy Form entry traffic + Complex column formulas = Inability to SAVE manual sheet changes
Story time. This is a long one, so buckle up! This post is for anyone who might be having issues with saving changes on sheets with complex formulas while many form entries or new rows are being created. (TL;DR summary and the real Discussion Topic at the bottom!) Last week, I put together a small Smartsheet solution…
-
Averageif and AND functions
Hello, I am lost and could really use some help. I am attempting to build a formula in the Sheet Summary to capture the Average Throughput of changes that are set with a particular Change Priority, Quarter, and Year. The formula I have is: =AVERAGEIF(Throughput:Throughput, AND([Change Priority]:[Change Priority] =…
-
Date update by a day but only when a box is ticked
Hi all I have a sheet which has a deadline on it. This deadline may be extended for a variety of reasons (unable to get parts, Waiting for a return email etc) Is there a way to have a check box that, when ticked, It'll add a day to the deadline automatically as it passes. At first, I thought this would be possible via…
-
Auto-populate a form field with the result of a formula in the sheet.
I have my sheet set up so that when I click the generated URL, certain fields of the form that the URL leads to are auto-populated with values from the same row. My issue is that it seems like I can only auto-populate manually entered values and not values generated from column formulas. Is there a way to do this? Maybe I…
-
Return value if a cell in the same row has highest value in the column
I'm working on an email campaign and want to see which issue has the highest open rate. If a value in Column C has the highest value in the column, return the value of Column A in the same row. I'm stumped. Can anyone provide this formula? VLOOKUP seems like the obvious choice, but I don't know how to reference a MAX…
