-
Why No Release Updates?
If I am not mistaken, Smartsheet had scheduled downtime this past Saturday to implement some improvements. Why is there no information posted to inform us of what those changes are? As the "go to" Smartsheet resource at my company, I should be aware of new functionality--regardless of how big or small. It may be something…
-
Date Calculation
I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really…
-
Indent under a lock row
Hello to all, I have a sheet for tracking material order. At the bottom there is a completed section with many parent child relation, see attached file. T0 completed, T1 year, T2 month, T3 project, T4 list of material. The sheet automatically lock every thing that is in T3 and T4. Rows in T0, T1 and T2 stay…
-
Formulas for using the symbols
Hello - I love the new symbol options for the columns. I'd like to use use the up / down arrows to help me track some $$ to budget info. I have been trying to figure out which formula to use via the templates and I can't sort out how to do it. I know I can use conditional formatting to accomplish something similar, but I'd…
-
Saving smartsheet in Google Drive
I can't seem to figure out how to save my Smartsheets directly into Google Drive. I have the Smartsheet Google app, and when I'm within Google Drive, it will allow me to create new Smartsheets directly from Google Drive, and then they appear in my Drive and shared folders. However, our team already has several Smartsheets…
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Creating Pie Chart with Non-numeric values
Hi, I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I look…
-
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
-
Move Project with Predecessors
I need help moving a project that has predecessors. This is being used for a production facility to track the status of our projects. However, I have run into a problem when needing to move a project in the order of production. The predecessors are not moving with the project change. -I need the "Design" process of the…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
