-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
How can get the most recently register of FSE from table 1 and send the name of FSE to table 2
Mi situation is that need review int the table 1 who have the 280.1 and once i identify the most recently register need send the name of the FSE who has the 280.1 to table 2 Table 1 Table 2 This I need
-
SUMIF and AVG or AVERAGEIF
Hello, I'm trying to use two different formulas that looks at multiple Criteria to return an Average Daily number of hours spend on tasks within a category and the other to return the total number of hours in the week spent on specific tasks. With only a single criteria I can get each to work, but I'm struggling with the…
-
Vlookup or IF statement
Hi, I have one sheet where I have an attendance list. I have another sheet where I have opportunity logging. From my opportunity logging sheet, I want to do a vlookup (I think ) of the email address to my attendance sheet email address. If they match, I want it to return "Yes" and if no, "No". Can someone please hep me?…
-
Email from two different sheets into one
Hello, I need to email information from two different sheets but my boss would like for that information to be in the same email. they do not want to see two different emails. Is that possible in smartsheet?
-
Calculating years of service
Hi there! I have a sheet that we use to track key dates for staff (anniversary date, years of service, etc. etc.) I have a formula that seems to be successfully calculating the years of service, but when I try to set this as a column formula I am getting an error message (and the help article really isn't helping). :( Here…
-
Can I count after a certain time?
Hello, I am using this formula =COUNTIF({Shipment Dump Range 1}, "yes") to count the number of yesses on my dump sheet. My question is, how can I modify this formula to count the number of yesses after 5pm for example?
-
IF AND formulas
I can't get the following formula to work, getting the #UNPARSEABLE error: =IF([Regulatory Impact Score]@row >= 3.75, "High"), =IF(AND([Regulatory Impact Score]@row < 3.75, [Regulatory Impact Score]@row > 2), "Moderate"), =IF([Regulatory Impact Score]@row < 2, "Low") If I separate these into three different formulas, they…
-
Is there a way to use a Report's "Summary/Summarized" value on Dashboard or Sheet?
Now that Reports summarize data (ie count), how can I use that value/result in a dashboard or metric sheet (via cell link)? Neither dashboards or cell links allow me to use 'reports' as the source data.
-
VLOOKUP over multiple sheet
I have a new sheet that has Full name and I want to do a VLOOKUP to determine their email address w/o asking them for it. I need to look across 4 massive sheets (almost 20k rows in each) and when the Full Name is X it returns their email address. I know how to do this if in 1 sheet but not across 4 sheets. Sheet names are:…