-
Contact List Drop Downs
Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-down and select John Doe as the main contact, but User B can't even see John Doe as an…
-
Automatic item numbering
It would be really good to be able to format text entries so that they are numbered automatically based on indentation level like: 1. Header 2. Header 2.1. sub header 2.2. sub header 2.2.1 sub sub header 3. header I actually wonder how it can be it is not implemented already? It is quite important to be able to reference…
-
Decimal Puzzle
This one might be fun. I have a number....let's say 32.1204 But what I really want is to have it be 32.12040 because I want to turn it into a string and peel off the right two numbers. I've tried ROUND(number,5) but that doesn't work. I can hit the increase decimal button and make it show as 32.12040, but then if I try to…
-
Working With Children as Strings
Here's a tricky one that has me stumped. I have parent/child arrangement of project task completion. Calculating total project completion by using a simple AVG(CHILDREN()) does not get me a true completion value for the entire project. Someone is going to tell me I went to a lot of trouble when I didn't need to, but what I…
-
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…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…
-
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…
-
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…
-
Cerco freelance italiano per assistenza
Cerco freelance italiano per assistenza
-
Sheet Summary Limit
Is there a hard limit to the number of fields we can add into the new Sheet Summary page?