Welcome!

Different sheets under one project

Hallo Smartsheet communit,

I am new to smartsheet, however, I am not familiar with everything as I am still learning abut it. I would like to find out if it is possible in smartsheet to create different sheets on one workbook as in Excel. I would like to create four sheets and link them with formulas. I am able to do that in Excel but I can't in smartsheet.

Kind regards

Salmon

Find more posts tagged with

Comments

Andrée Starå

Hi Salmon,

Yes, you can! You can create four different sheets and then link them together with "cell linking" or depending on your specific use case, you could maybe use reports instead.

Please see attached links for more information.

https://help.smartsheet.com/articles/861579-cell-linking

https://help.smartsheet.com/articles/522214-creating-reports

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Salmon Tangeni Kambunga

Hallo Andree,

Thanks very much for your swift reply, I highly appreciated.

There are few things I would like to find out from you.

The cell linking seems to be perfect, but I noticed that I can't link blank cell. I just want to update one sheet and it will automatically populate to other sheets which are linked to it.

It is possible that, if a certain condition is met in one particular cell and then it will populate the next sheet with full description. For instance goods registered in sheet one has been fully received on 20.05.2018 in sheet two, and I want the full detail to appear in sheet three just by entering the date in sheet two.

Kind regards

Salmon

Andrée Starå

Hi again Salmon,

My pleasure!

It can be blank, but something has to have happened. So, for example, you could change the color and then change it back.

I would need more information to be able to answer with certainty, but it seems like it would work. There needs to be a thorough thought thru a process to make it work though.

I'd happily work with you and help you with setting up a solution.

If you'd like we can book a time for a free discovery call. How does that sound?

Please e-mail me at andree@getdone.se and well take it from there.

Best,

Andrée

Andrée Starå

Hi Salmon,

How did it go? Did you manage to get something set up?

Best,

Andrée Starå - Workflow Consultant @ Get Done

Sign in to join the conversation!

Quick Links

Trending discussions

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…