I have a sheet with the following formula in a column titled "Status": =IF(ISBLANK([PO#]1), "Processing", IF(INDEX({Status Range}, MATCH([PO#]1, {PO Range}, 0)) = "Loaded", "OTR", IF(INDEX({Status Ran…
Hi everyone, This may be a basic answer, but I am trying to build a dashboard for my company. I have 6 reference sheets that I want to filter into 1 large sheet (the dashboard). The dashboard is an ac…
I have an Excel sheet that I pull data into from another system and then run a macro to organize it the same everytime. Is there a way to simply upload that new data over an existing sheet so I can us…
I have watched many videos but cannot seem to master the cell linking between sheets. I've tried multiple ways but never receive the results I'm looking for. I have a project on a sheet Named Eblasts …
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 smar…
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 Thank…
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 bid…
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 funct…
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…
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, pro…