-
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…
-
Can I use Find in a count formula?
I have a spreadsheet that is a calendar for consultants. I have the primary column using the consultants name as the Grandparent, the Month as the Parent and the weeks of the month as the children. * Consultant * Month * Week * I have another column that shows availability using RYGG for different status'. * What I want to…
-
Conditional Format by cell unique based on row or column
We are undertaking major project across teams and areas and looking for a way to create a dashboard type display with ability to add spcific details. Basic requirements include. 1. We have 16 different workstreams grouped by column (overall status, staffing, planning, security, rerporting etc.). There are about 30 modules…
-
How can I see a dashboard of all my projects - from Home Page?
Is there dashboard view for all my projects? Something that launches as Home Page?
-
Excel template that generates (automatically) formulas for smartsheet
Hi Guys, I made an excel (macro enabled) that allows to my team create projects easily and faster. The file generates (automatically) formulas for smartsheet. I publish the example here You can register time here This is the video The video is in spanish, I will translate it in the coming days. Regards, Álvaro
-
Conditional formatting for columns, informed by row-level input.
Hi all I am building a template for which the top row has date columns set up so that all date columns change color based on the date (today/tomorrow/yesterday). The first 2 date columns are, Start Date, End Date, and are not the concern. The remaining date columns, Milestone 1, Milestone 2, etc, are dates which are pulled…