-
How to extract the email address from column having Contact Type
Here in the "PM Name" column, I have a value which is of Contact type. I tried copying the value over to the next column, then i get the Email address Prefixed by my name(Manasa M S<manasa@gmail.com>).In the next column I want to extract only the email address(eg: manasa@gmail.com). please share if you have formula for…
-
How do I use Averageif when referencing a new sheet?
=AVERAGEIF(OTP 10.21.23 SCAC Range), "CFAA", (OTP 10.21.23 dwell TIME) This is the formula
-
How do I add the Year to capture 2023 and 2024 data seperately?
Hello, This is the formula that has been working great. But with 2024 fast approaching how do I add the year. =SUMIFS({Rounding| Number of Staff Contacts}, {Rounding| CPD Educator Name}, Category@row, {Rounding |Date Rounding Occurred}, AND(IFERROR(MONTH(@cell), 0) = 1)) Thank you for any help, Lori
-
vLOOKUP SOMETIMES RETURNS NO MATCH
Hi Everyone, Thanks to some very helpful advice on here I've amended our company quotations sheet to reference a credit checking sheet and then show if a client has been credit checked and what their limit is. 99% of the time this works perfectly, from time to time however it returns #NO MATCH this is without exception for…
-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
Help with bar graph on Dashboard
Hi everyone, Hoping to get some help on a bar graph that is racking my brain a bit. I've made a sample of info i'm trying to chart: What I am hoping to do is: Have Joe and Dan on the X axis Both Joe and Dan have two separate bars, one for win, one for loss, and have total number of "wins" and "losses" on the Y Axis Have…
-
averageif
I am trying to find the average dwell time per SCAC but I'll get a zero return which is not correct or a #divide by zero error message. =AVERAGEIF({OTP 10.21.23 SCAC Range}, "ltga", {OTP 10.21.23 time}). Can you help me find a formula that works properly?
-
Is there a way to create a range in a formula that never changes, even if rows are inserted/deleted?
I have a sheet I'm working on that pulls data from form responses. I don't want to have to pull from another sheet if I can help it. I have a lookup like this: =IFERROR(VLOOKUP("Form1Answers", [Col]1:[Col25]5, 3, 0), "") This works fine until the form returns data and inserts the new line. When that happens, because the…
-
LOG Function
Is it possible to calculate (or even approximate) a LOG function in Smartsheet? We regularly use the below formula to calculate A/E fees: (35/LOG(Construction Cost))-1.15)*(Complexity Factor) = A/E fee % I have a sheet setup where someone can enter a construction cost, and a lookup table for the complexity factors based on…
-
Tracking the Specific Time of a Cell in One Status
Hi all. I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row changes with helper columns, I really cannot figure out how to do so specifically for one cell. Any recommendation on how…
