-
Formula Help
Community - Please help reduce this formula. My IT guy did it in 5 mins, and he said its crap, but it works. However, I now have to put it on ALL my projects and its too cumbersome. I didn't even try to do the formula.....I am too busy Here you go...and Happy Friday!! Louise=Amount6 - (IF(ISBLANK([Date Payment…
-
Feature Request: Row Summary Documents
Our business utilizes Smartsheet in so many ways. One feature that continually wish Smartsheet had is what I call a "Row Summary Document". This feature would essentially mimic the Form builder already contained in Smartsheet, however it would be in reverse. The form would actually be populated based on an already…
-
Expanding a line and losing any lines beneath it.
On my Entresto PPEP 2016 Sheet-- When I expand line 46, everything beneath it is lost. How do I fix this?? Thanks!
-
DATEONLY Formula Error Message
I cannot get my DATEONLY formula to work. It keeps giving me "missing or invalid parameters" as the result. I am trying to create a formula that gives me a date variance between Planned Start and Actual Start. My two column names are Planned Start and Start and I am trying to start in row 5. This is the formula I have and…
-
Resource location dependency
Hi, Is it possible to constrain resources based on location? Maybe have a dependency or something that would allow me to schedule only North East resources on projects located in the North East. If none are available, I'd be able to override this dependancy as well. Thanks!
-
Formulas
I have two cases where I need a formula to work for me The first one is easy. I have two columns - Delivery Date and Delivery Date (2). I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell. I tried =[Delivery Date]1 but I get an error that says #number expected.…
-
Setting a project due date, then building tasks with predecessors leading into it - not working righ
I know there is a way to do this but for some reason I am stuck. I have an event taking place on 5/25. So that needs to be the due date and it CAN NOT MOVE. I then have maybe 40 or so tasks leading up to it, all of which have to occur in certain sequences. I am not able to set up the project. One of two problems occurs.…
-
Project Management: Notices to be sent out to clients
Good day, I have ongoing jobs with my clients that require deadline notifications of 3-year renewals, annual and quarterly requests along with reminders. I use Smartsheet as a checklist with the various dates and when to start processing these reports. The issue that I am having is that my clients do not wish to log in…
-
Wrong sorting order with numbers smaller than 1
Hi there, we are using a column "Estimated work in days" with a DropDownList with the values: 0,25 0,5 1 2 5 10 n.a. t.b.d. Please consider "," here in Germany is the decimal separator. Sorting the rows in a sheet leads to an order were rows having 0,25 or 0,5 are listed below (or on top) of t.b.d. In reports the sorting…
-
Ignoring empty lines and blank cells in Import feature, losing lines and format
I'm not sure if this is a known or new issue, but I just discovered it today, and it's not cool. While importing a spreadsheet that has 17 columns and 350 rows, I found that the file I imported into SmartSheet was not like the original. I identified two problems: Starting with the worst - if the first cell in a line is…