I have several different sheets referencing the same metadata sheet. Should all of my different sheet formulas use the same naming convention for the range? Or can they reference the same range but wi…
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, t…
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,…
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.
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…