I've seen a similar request for referencing the parent Workspace (though I didn't see an answer) but I am interested in referencing the name of the actual Sheet in a cell within that sheet. I am plann…
I have cell one that has a function in it say IF(1=1,true,false) and it outputs true. I then want to do a vlookup for that true value, but I keep getting that no such value exists. I assume that's bec…
Further to a considerable amount of Community requests for a way to Update Dropdown Lists in just one sheet, then have that list Automagically populate all the other Smartsheets that reference that li…
I am working on an "issues log" in smartsheet and I want the ability to respond to duplicate issue by marking it as duplicate (checkbox) and the next column (Duplicate Of) place the auto numbered row …
Hello, I would like to know where I can go to make edits to some of the ranges I created. Normally, I can see the ranges I have created by just clicking on the cell once (rather than double-clicking t…
I am looking to create a formula that will capture all active rows that I have that fall withhin a Fiscal Year of 10/1/17 through 9/30/18. As of right now for the new fiscal year of 10/1/18-9/30/19 I …
Hi All! I searched for this, but couldn't find an answer. Maybe it doesn't exist! I'm trying to set up a new dashboard for sales reps. In one sheet I will have them fill out all of their activities. I…
Hi, I need to create a graph that track history of project evolution / execution. So, I need to have a report that contains the date that %completed was changed and the % that was added so I can creat…
Hi, First, thanks for members of this forum, you’ve been a great help! I have one main sheet where all (different) legal tasks are listed to help the legal team manage the work load. Only the legal te…
