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'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
