-
Sorting sheets in a workspace
As of this morning, I have found that Smartsheet is defaulting my sort order to Name. I can change to Last Update on a specific workspace, but when I click into another workspace, it defaults back to sorting by Name. Previously, the sort would stay with the last setting. As I prefer to sort by Last Update to quickly see…
-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?
-
Countifs with dates
Hi I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong.... =COUNTIFS(Created:Created, >= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content…
-
clone questions
Hi, I want to "clone" the following items from one sheet to multiple other sheets. I don't want to manually redo everything. Is there a way to do it: 1. Clone a workflow: I set up a workflow in one sheet (trigger is a date). Can I "push" this to the other sheets with the same structure? 2. Clone a Conditional Formatting:…
-
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?
