Sign in to join the conversation:
New to smartsheets. How do I add in weekly meetings into a project (all on one line.) It is a long project and I don't want an entry for each meeting. Thanks in advance.
Hi Julie,
I'm not exactly sure what format you're using to add meetings into your sheet. If you're using a series of columns to log various different kinds of information, it's highly recommended to add them as new rows so that they are easy to read and logically divided.
You can use hierarchy in your sheet in order to group your meetings under a single project. More information on hierarchy is available in the help center: https://help.smartsheet.com/articles/504734-hierarchy-indenting-outdenting-rows
If the above doesn't help, please provide me with more information on how you're adding projects and meetings to your sheet, such as what columns and column types you're using and whether this is added by a form or directly to the sheet.
I am new to Smartsheet as well, and I decided to use a separate sheet for a few reasons.
I wanted to create an agenda before the meeting, and I wanted to share the sheet with people that may not have access to the tasks & milestones, such as external partners. Also, I will track tasks that do not need to be added to the formal timeline.
I am using the following columns: meeting date, attendees, hot topics, tasks, next steps, priority, assigned to, due date, comments, status (in progress, complete, ongoing, hold, cancelled).
I use the hot topics column to create an agenda, where I can add topics as I think of them before the weekly meeting. I usually add hyperlinks to other sheets that are related to the topic so the I don't waste time finding the sheet.
I filter out those with a status of complete or cancelled so that i can keep the sheet updated with items that require follow-up.
Good luck!
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…
