=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 pr…
Is there a way to alter the Column Headers? IE Bold or Sizing or Font? I haven't seen any of these options but I just want to verify that it is truly the case.
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The for…
Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and w…
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…
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 du…
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered…
Hello everyone, I've been using Smartsheet to keep a timeline for my projects in Jira. So far everything has been working great but I noticed an issue when reordering rows. When I do this, after a few…
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates …
