-
Dynamic View - Drop down list in 'Details Panel'
With in Dynamic View's details panel is there a way you can start to type some of the drop down information to pull up that option instead of scrolling for the right one? See below 'Market' can't type. Am I doing something wrong or is this by design? If by design I vote for an update.
-
Is there a way to move a dependant date further out without using lag?
I have a background of using MS Project where 'predecessors' are the equivalent of 'dependencies'. I have got used to smartsheets pretty quickly and for the most part get along with it but feel that there is a definite limitation when using dependencies as follows: In MS project if I have line 1 completing 28/11/23, I can…
-
Formula to add leading zero to months 1-9 of the year only.
I need to add leading zeros to month numbers Jan-Sept only as sorting by month number does not work due to Months Oct-Dec starting with number 1. If I sort by month number, it comes up like this. 1 (Jan), 10 (Oct), 11 (Nov), 12 (Dec), 2 (Feb), 3(March) ... Does anyone have a formula for this?
-
INCORRECT SAVING
***Translated by a moderator as the Community is currently only supported in English*** GOOD MORNING, I CAN'T SAVE MY FILE BECAUSE THERE ARE PROBLEMS WITH SMARTSHEET
-
How to prevent row data from shifting up a row?
We have a data sheet set up within SmartSheet (Sheet A) that feeds off our master sheet (Sheet B) that contains all of the current positions within our company. This automation is set up so whenever a new position is created in Sheet B, it'll auto-feed the position name into Sheet A into Column 28 of the screenshot. The…
-
How do I add a space in a reference formula? I want the space to display between the two values that
Good Afternoon, I have built an event calendar tracker. I want the display name on the calendar to include information from two columns of data. The formula I am using for calendar display is =Location1 + [Event Name]1. In the calendar display column I want a space between the location and event name.
-
Is there an easy way to build a report with same order of columns.
First off - I am more than experienced at report building. But when it comes to a sheet that has 250+columns, picking the columns in order you want them in your report is very tedious. The other option is click and add lots of columns and then drag them into their right sport/order, which is even more tedious. There should…
-
Can a Form have multiple entries and have them display as multiple lines on the smartsheet?
I have a form I'm using as a maintenance work order log. I have them fill out a form, which in turn fills out the order log. Is there a way to have them enter multiple parts and descriptions and have them populate on multiple lines in the smartsheet order log? If they do have to enter a form entry for every part they want…
-
Check box for parent row only
I have a sheet where there is a helper column that says either Parent or Child. If the helper states "Parent", I want the checkbox in a column named "Report" to be checked. Otherwise (if the Helper states "Child") I want the checkbox in the "Report" column to be unchecked. Can this be done with a formula or conditional…
-
Smartsheet Application Zoom Function
Smartsheets does not support browser zoom levels under 90% and begins to misalign rows, columns, dashboard widgets and more. This is still an issue within the smartsheet application and continues to shift and misalign data and widgets. Specifically building a dash board is very challenging as the alignment tools made to…
