-
Why are my durations not calculating correctly, and how can I adjust this?
I'm working through a rather complicated column formula and ran into something that seems to be native to SmartSheet. It appears to be rather minor, but is throwing the whole thing off for me. If you look at the first row that has dates in it, for example, you'll see that the row starts on the 1st and lasts 10 working…
-
AI integration of Smartsheets
Hi all new here to the community, I had a question around brining AI into our Smartsheet platform, managing portfolio of over 1400 projects. Anyone suggest a good place to start?
-
How do I check an entire column for a particular value and only display the lowest example of it?
The question title is kind of confusing, so here's what I'm looking to find out. I'm making a Project Plan sheet, and want to have a place that updates the estimated completion date based on how the project has progressed thus far. There are more columns in my sheet, but my question is only related to the ones in the…
-
VLookup returns nothing for assigned to requiring multiple answers
Hi All, I am working on a project plan where I have a drop down that I can select multiple roles to assign a task to. The Vlookup references a contact list of single role, single assigned to. When using a simple vlookup formula, it will give a single answer where there is a single assigned to, but what do I do to make it…
-
PM Training
I am in search for Project Management training for the financial sector. I started with google search and decided, what better place to ask than the project managers using Smartsheet. Is there any initial training, certifications that you would recommend? Thanks!
-
Question About “=[]#” Formula in Smartsheet Template
Hello, Our team is reviewing one of Smartsheet’s templates to manage marketing campaigns. The template includes multiple sheets, reports, and a dashboard. However, in the Plan sheet, there’s a column formula that reads: =[Campaign Name]# I’m trying to understand what this formula is doing. There isn’t a column named…
-
Request for Flexible Editing Access for Free Members on Project Plans
Hello Members, I hope you’re doing well. We’re a small team of six members with a Business License — three licensed admins and three free users — using Smartsheet to manage and track multiple project plans. As admins, we create new project plans directly in Smartsheet and import some from Microsoft Project. However, our…
-
My client, an unlicensed user is not receiving their validation code
Sorry for such a basic question, but I have looked every where and reached-out to SmartSheet support. My client, an unlicensed user is not receiving their validation code to access the smartsheet I've created as a licensed user. The code is not in their junk or spam folder. Any thoughts on how to fix this? They've followed…
-
How have you secured buy-in from other departments (business, sales, etc) to use Smartsheet?
Hello! Any tips and tricks to encourage the other departments (outside of Project Management/PPM) to use Smartsheet?
-
Task Status Update based on Previous Step Completion
I've been asked to lock the "Status" column and only allow changes to the "% Complete" field by the assigned task owners. This admittedly will limit the use of all the status' as I'm trying to develop a strategy to simply change my approach and limit the functionality options. My Status column should ideally include the…