-
Harvey Balls / Lookup or Max ?
Dear all, I am trying to find a smart way to use formulas to make a large data table more accessible. The situation is as follows: I have a number of companies that are represented by one line in smartsheet. This line included a unique ID as well as names, etc. For each companies I can have 1 or more lines - children -…
-
Creating more than One Link in from a sheet to another sheet
I am trying to get a sheet to link into another however we want to be able to use the sheet over and over again and have it where it will link in new rows. Is there a way to do this? Please Help Thanks
-
Auto-populating a sheet with filtered data from another
All, I'm hoping someone can suggest a solution. I am trying to reduce the amount of time spent re-entering data about upcoming bids from one spreadsheet to another. My company has a master list of bids over the fiscal year and every week my boss produces a separate sheet of just the upcoming bids that he can then use…
-
Creating Web forms with Auto-populated form content
I see that you can auto populate a section of the form by manually entering (post-URL): &ColumnName=text where any spaces in the text are replaces with %20. Question: I first used the substitute function to replace %20 for all spaces in a column that contains the desired text. But am unable to have the sheet pull that…
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
In excel you can have multiple worksheets in one document. How does this work in smartsheet?
In excel you can set up multiple tabs or worksheets in one document. How can I best do this using smartsheet? Any tips? I have a excel sheet from finance using multiple worksheets and staff names, project codes and formulas for high level tracking of time against multiple strands of work. I would like them to use…
-
Identifying all links in a sheet
Another Smartsheet newbie here...I'm sorting through 25 (ish) sheets and there are multiple links between them. Trying to quickly identify all of the Links In and Links out for each sheet to quickly assess how everything ties together. Is there a quick way to pull this info vs. trolling through each sheet?
-
Can I partially mirror a sheet?
Hi, I hope someone can help me with this. What I'm trying to do is find a way to automatically share some information from a sheet into another. For instance, I want to have a sheet with all the relevant information for the company's projects, including financial information. Then have another sheet mirror most of it…
-
Constructing URLs to particular rows in sheets
Hello, I am collaborating in a project and most of the work being conducted is external to SmartSheets, which is being used as a planning tool. I would like the ability to construct an URL / Hyperlink that references particular tasks / rows. The idea is that as the project SmartSheet gets extremely big and with multiple…
-
SUMIF Formula - "Dragging" to Copy
For the formula below, when I drag this formula, which references another sheet, across columns in the sheet that I'm writing it, the column referenced in the formula doesn't change. Even though I've done nothing to anchor it, it just remains anchored on the column against which I wrote the original formula, in this case…
