-
Accessing Project Plan from someone no longer with the Org
How do I access a Project Plan that was owned by someone who is no longer with the company?
-
Smartsheet Employee Dashboard functioning like an app
Hi there I have created a Smartsheet Dashboard for each employee, with sheet visual icons related to their worksheets. It serves as a quick link and hosts only the sheets they need to access and work on. The Icons are categorised as per our company's production and accountability structures. It resulted in no further…
-
Seeking automation for Monthly Dashboard with separate Month Rows
Hi all - i am building a monthly dashboard with separate columns for each month's status, key takeaways, and next steps. I am wanting to build an automation that says for example: 'your {{current month}} status update is due, your last {{last month}} update was {{status color}}. Please be sure to indicate your key…
-
Idea funnel
Hi all, I'm at a manufacturing company. I am looking into a Smartsheet solution for idea generation and management. These could be cost improvements or reach into new product development. We would likely have project goals (improve margin, expand sales, ect), ideas (that need to link to SKU's and goals) and gather input on…
-
Using SUM with child rows
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
-
How to optimise my currentTimesheet solution
Hi community, hope you are all spending a great xmas period. I'm here to ask you advice on how i could improve or change completely the architecture of my timesheet solution. I have setup up a sheet with the following main columns: Work date - Contact - Project Name - Activities A total of 15 users enter their activity…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Using AI and Voice to Simplify Task Updates in Smartsheet
Hi everyone, I wanted to discuss how AI-driven input methods, especially voice, could simplify everyday tasks and update workflows in Smartsheet. In many project environments, updates, action items, or follow-ups arise during meetings, calls, or brief discussions. These are often added to Smartsheet later, which can lead…
-
Smartsheet form with built-in AI
You could have a form with built-in AI. Eg: we have a form that becomes a row in our matrix tracker Smartsheet. For example: Marketing Manager Geraldo works with AI, so the form will start asking his name/email. Based on that, the form will make suggestions(what kind of Asset: Brochure, Flyer..) , category(AI for industry,…
-
Need to add total track the amount of times a person signed out equipment in 365 period from today
Here's the formula I'm using put it's coming back unparseable =COUNTIFS(Name:Name,"Yes", [Date signed out - OVERALL]:[Date signed out - OVERALL], AND(@cell >=TODAY(-365), @cell ,=TODAY(365) Appreciate any help.