-
Project Porfolio templates?
I am new to the community. I run a professional services organization and we use smartsheet for basic project management. I am interested in learning if Smartsheet has any Portfolio Management capabilities. Can anyone make a suggestion as to where to get started based on their experience using Smartsheet for Project…
-
Work Orders
Been using Smartsheets for over a year with just some basic tracking sheets and task lists to share. Ready to make the jump into more complex sheets. I have 18 warehouse facilities across the country and trying to come up with a sheet to track the numerous work orders that come through my office. Was thinking of creating a…
-
Populate Sheet Summary with Form?
Hi there, I'm learning Smartsheet, so apologies in advance for the basic question. Is it possible to populate the Sheet Summary via a Form? If so, how? We have a sheet we want to create with minimal structural information in place, and the Form should be used to supply metadata we use to track and manage the sheets…
-
Count Number of Records in current year
Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In Date of the record is the same as the current year. I have the formula in the pic…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Jira ticket linking (blocked by, breaks down, etc.)
I use the jira connector to do our planning in smartsheet and push to jira. I'd like to link tickets to note, blocked by or breaks down, etc that exist in Jira, but I can't figure out how to do it in my Smartsheet planner. Is this possible? If so, how can I accomplish this?
-
Will creating a baseline report duplicate resource allocation?
Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustrated here is to Save As New the original plan (BEFORE you modify any dates), and save it outside…
-
Be great if Smartsheets could be used offline
A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.
-
Accidentally unsubscribed from notification in a row, how do I get the notifications turned back on?
I was scrolling through a notification email and accidentally clicked on "unsubscribe from notifications". It did so immediately instead of asking if I was sure I wanted to unsubscribe (like most other programs do). I don't know how to subscribe again, it is on a row that I have a task assigned so I need to be able to see…
-
Unexpected movement of rows
Hello, A sudden shift of rows happened while using smartsheet. The detail is as follows: Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inputing data in some cells. Then, suddenly some data appeared in rows where no one input…