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 wa…
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…
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. Thi…
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 work…
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…
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 detail…
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 formu…
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!Email…
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 >=1…
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 P…