-
Counting Text Color
Hello, I am working on creating metrics in our Smartsheet milestones. Currently, if a milestone was completed on-time, the date completed is turned green. If the milestone was not completed on-time, the date completed is turned red. What I would like to do is create a formula for metrics that reads the text color for how…
-
VLookUp - #INCORRECT ARGUMENT SET
Hello team! I'm trying to reference all of the columns from one smart sheet (let's call is smartsheet A) to another (smartsheet B). Here is my formula: =VLOOKUP([Helper Column]@row, {Smartsheet A}, 7, true) 7 is the location of the helper column in both smartsheet A and smartsheet B. All of the columns in both smartsheets…
-
Convert text to contact
Hi Guys How can I convert text to a contact? I have a contact column - Recon Preparers, but when i use the formula below it returns a text instead of contact.
-
JOIN/COLLECT Duplicates
Hello Smartsheets, I was looking for some advice using JOIN/COLLECT. If I'm using JOIN/COLLECT to pull from a column that has repeat instances of the same value (in my case vendor names) is there a way to only show one instance of this name on the sheet they are being displayed on? So that I do not see the same name shown…
-
Column Formula to Leave Child Row Values Alone and Average or Sum them in Parent Row
So far I have been able to get three formulas to work, which include other formulas, but now I am having an issue pulling an average or a sum when the child rows do not have any formulas embedded. The following work when I convert to a column formula: For a Sum: =IFERROR(IF(C@row > 0, SUM(CHILDREN()),…
-
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 ),…
