-
Project Plan with hour:min level predecessor
I have searched through several other posts and I have not been able to find anything related. I have a use case for an hour-by-hour plan that will happen all within a single weekend. (Project cutover). I want to be able to update a start time and end time column based on a duration of 15m, or 1h, etc. I can use the minute…
-
Is There A Way To Automate "Clear Contents" of a Cell?
We have a Status Update dropdown menu that has to be updated every day before 1:00PM and then we generate the report from the Activity Log at 2:00 PM. The users are complaining that the "Save" option doesn't come up if they don't make a change in the Dropdown menu. ( In some cases the Dropdown option Status they select…
-
Data validation for numbers only doesn't work on mobile devices
A very recent feature to validate data types as numbers only on forms is not working on mobile app or mobile browsers if you use decimals. Only whole numbers do not give off "Enter a valid value" error over the data entry box. Desktops are unaffected, however, as I can enter decimals with numbers fine. I just changed all…
-
Specify Row Number to Create a Card
Hi! In Grid view my last row with data is #19. When I create a card in Card view, it creates it in row #57. Why won't it create it in the next empty row, #20? Not sure why it's created so far down the Grid view rows. This is problematic because I have formulas with range of rows #6 to #30. So the new card is outside the…
-
Calendar View
Hello, I would like to have my grid locked in calendar view. As it is right now, users would have to select that view for themselves. Also, how can I have a report that is in calendar view display as such in a dashboard? TIA. -BR
-
Using a URL Shortener for Form URL's
I have created 10 forms. I used a URL shortener to shorten all URL's. I tested all URL's and all were working 2 weeks ago. Now for all URL's I get the message "The form you are attempting to access is no longer active". I have checked and confirmed the form is active. Any ideas on why the form would show active, but the…
-
Share Part of a Sheet that's Editable by Non-Smartsheet Users
I have a sheet that I would like to share part of the columns with others and allow them to edit. The users I am sharing with do not have Smartsheet accounts. Using reports wouldn't work since I can only publish as read-only, and publishing the sheet itself would include all of the columns. Is there another way to do this?
-
Form Manager
I am using the Smartsheet.gov; and the form manager looks completely different. I verified the differences as I watched both best practices webinar and the gov-course-4-gather-data-and-report video under the gov site. But I don't see any mention in the gov community of conditional logic FAQS. Can anyone verify if the…
-
Is there a way to get the sheet (grid view) column order to match the order of the form
When building a form we tend to start with some data in the sheet, and then build the form from that. As the form develops we add elements throughout the form. Unfortunately this then means that the Sheet (grid view) order does not align with the form order. I realise I can move the columns manually. I was wondering…
-
how to chart datas over a period?
Hello Everyone, I am struggling to find a way to chart this data, where I got hours of each resource required for each project. Trying to chart total number of hours of each resource over a period, lets say for the next 3 months of project lined up. I am at a stage where I can only be able to chart them per project of each…