-
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…
-
When will Smartsheet be able to produce comprehensive reports and link Gants charts into WBS's?
I'm an advocate of the intuitiveness of smartsheet and use this programme over other PM software for gant chart use. I find it is more user friendly, easier for collaborative use and the fact I can use this on all platforms. My question is, why does smartsheet not have the ability to produce WBS and comprehensive reports…
-
Can I build a resource pool to choose from for multiple projects?
Is there a way to build a data base of human resources (assigned to) that I could choose from when working within multiple projects? Is there a way to indicated allocation % of that resource so I can understand if certain resources are being over-allocated or under-allocated?
-
Formula help...
I've tried a formula that seems to work, in that it doesn't give me the lovely "Unparseable" or "Missing Operator" message. Here's the scenario: If Column A (text column) contains "These words" then Column D (date column) = Column B (date column). Column A does contains the needed words, and Column B is a date. But Column…
