-
Mailto: in a sheet
I am trying to create hyperlinks to email addresses in a sheet. I’ve tried two methods. First, was putting the email address in one column and then using a formula to add “mailto:” in front of it. This is adding the text but they are not clickable. I also tried using =HYPERLINK("mailto:" + [Email Column]@row, [Email…
-
Index formula help with a global update when referencing template metadata sheet
Hello! We are using the Control Center. In my template folder, I am adding an INDEX formula to a sheet that pulls information from the metadata sheet. It works great, and in my next provision, it works! Viola! I love it. However, when I try to do a global update, the formula fails to redirect to the project-specific…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Countifs formula Error
Hi, I have one main sheet and i'm going to pull data from that to another sheet, in this case i need to count my new Client Details within the particular date range, the problem is Project name details is repeating in the colounm (Single project has multiple products so i've kept seperate entry for all the products due to…
-
Formula If its Blank
I have this formula: =INDEX(COLLECT({DS-Email}, {DS-Office}, [Office Helper]@row, {DS-Title}, Title@row), 1) that works. I want to add "And when Termed Date column is blank." I came up with this formula: =IF(ISBLANK([Termed Date]@row), INDEX( COLLECT({DS-Name},{DS-Office}, [Office Helper]@row, {DS-Title}, Title@row ), 1 ),…
-
Can I set a cell equal to all data from a column of another sheet?
I want to pull a whole column of data from Sheet1 into a single cell on sheet2. The name of the column on sheet 1 is "Emails". I can't get a formula to work. cell formula something like ={Sheet1!Emails}? I am pretty new to Smartsheet formulas.
-
Formula Question
Hello, I have a scenario where I want to build in an If AND formula and just am not too familiar with how to set it up. I want to set it up as follow: If someone's age is >= 55 AND their tenure is >=10, I want the column to state yes. If it does not meet this criteria, I would like it to say No. Could someone help me set…
-
Increment previous row by 1 using column formula (when condition is met)
Hello Smartsheet Community, Looking for what should be a simple solution here: ultimately need to increment count by +1 once a new Project name is entered in a new row. If there are 8 Items within a Project, they will carry the same Project Count value, until a new Project is entered, after which Project Count increases…
-
Count when 2 Conditions are met
I have a field called Status & a field call Health (using RYG symbols) This =COUNTIF(Health:Health,"Green") counts the symbols correctly. But I am trying to count Status "Open" that have a Health "Green". So I tried using COUNTIFS… =COUNTIFS([Health:Health],"Green",[Status:Status],”Open”) Gives #UNPARSEABLE 😕 Can anyone…
-
COUNTIFS Status and Year is Current(Cross-Sheet Formula)
Hello Community… Stuck trying to work out a COUNTIFS formula for Status is X and Year from a date column is current year, The first part I have… =COUNTIFS({Status}, "Pending Submission", The second part I am looking for help in this the {Submission Date} which is currently a date column is the current YEAR. I have this…
