Best Of
Re: Saving a "Form" for later use without submitting as of yet
We NEED something like this and can be considered a hurdle to some people to actually complete a form enough to submit. We even have to design our existing forms with this in mind so we end up not even capturing all the information we need
kxgarin
"Submitted_at" in a report that can be pulled at any time
Right now "submitted_at" the time that a resource submitted their timesheet at is only located in the audit log. The audit log can only be pulled once a month and is not an advanced report that can be pulled into SmartSheet. My team would like the "submitted_at" field to be in the timesheet detail report or another Resource Management report so it can be reported on each week through an advanced report.
I understand this can possibly be done through an API call but it would be more straightforward if it can be pulled as a report.
daniellehh
Re: Merging CountIFS and Contains
You have CONTAINS("*UE*", @cell ) with the search value as "*UE*" but you don't have any asterisk (*) in your data.
If you are thinking that * is a wildcard, it isn't. CONTAINS is searching for an exact match of what you have between the quotes.
so, it should be just Current formula: =COUNTIFS([Study Number]:[Study Number], CONTAINS("UE", @cell ), Species:Species, "Rat")
Darren Mullen
Re: New Form update is buggy!
Hello @ArianaRiera ,
Thank you for bringing this to our attention! We've determined that forms not allowing users to make selections is caused by a bug and our Product team is working on a resolution.
We are not able to provide a time-frame on how long the resolution could take but we are doing our best in order to have this fixed as soon as possible.
Cheers,
Marce.
Marcela
Re: Rows Seemingly Moving by themselves
Is there away around this problem that has been lingering from reading the above notes, for the last few years. I'm having the exact same problems as listed and using the sheet in the same nature as "Sammy" is (the first entry in this thread). It is just me and one other person using the Smart Sheet. Even if one of us is away for the day, it will still shuffle on its own. Please let me know how to turn this feature off. If it can't be disable, I will need to use another platform, I'm spending 2-3 hours week undoing this automatic sorting/saving mess.
Chris_Empire1
Re: Forms were updated?
I agree with Lindsay……the forms are rather large - need to zoom out the page for comfortable viewing.
Is this something that will be addressed?
dminenna
Creating a Form that populates data from a Sheet
Is it possible to create a form that autopopulates information from an existing sheet? As a step one in my process, I have individuals filling out a form. For example, information such as name, email, location, etc. For step two, I'd like to pull answers from those questions to autopopulate the next form that needs to be filled out.
Lou Candiello
Re: Datasources for Dropdown Menus
I'm here to add my desire for this feature as well. I am currently waiting for my list to update itself using Data Shuttle and am currently at the 5+ minutes mark for it to run so that my drop downs will be updated. Having to Data Shuttle in and out for every drop down menu that uses the same source list is so inefficient that I question how Smartsheets is saving me time because as I build more and more sheets that need to use drop downs from the same lists, managing all of these Data Shuttles is getting out of hand. I have to manage a core list of 250+ schools and I manage multiple Smartsheets for 6 different maintenance areas. Please prioritize this feature. Thank you.
Teri Simmons
Re: Licenses and True-up confusion
@Loann McGee - Here is SS's intro article on Dynamic View - Smartsheet Dynamic View | Smartsheet
We use DV's a lot to break through the noise of a Sheet. It allows to show only the columns and rows that we want someone internally or externally to see WITHOUT having to sharing the source sheet. Then when clicking on a row, a pop out on the right will appear that will allow more and/or the same data to be shown (and edit if you decide), comments and attachments. Similar to a sheet but visually different. However since the user shared to the DV isn't shared to the source sheet, you cannot properly @mention something in the comments which is a huge fault in my opinion for collaboration.
We build our DV's off a Report instead of directly from a Sheet. It allows for greater filter options and/or a second layer of filtering options. We then usually embed them in a WorkApps and add other assets for our Partners but we've also added direct links to Dashboards or inside Sheets as well. We then only need to share the WorkApps (besides any DVs that are embedded in the WorkApps). It gives an easier user experience, navigation and partner branded professionalism for our Partners who don't normally have Smartsheet. This is just once example for us.
More advanced users can use Field Logic in the Details panel which is a nice feature. Meaning you can selective pick which cells are visible only, visible and editable, or just hidden based off a criteria. Example, a ticket status system, if it's in Stage 1, all cells are editable, but if it's in Stage 2, only certain cells for approval are editable, etc. So depending on the status, the cell options can change. There's other great features as well not mentioned.
I hope that helps.
MHalvey55
Colour scale on column values
I would like a colour scale applied to column values, similar to the Excel colour scale conditional formatting capability. Pick the colour extremes and let the system shade the background from the highest to the lowest values accordingly.
Yes, I know I can recreate it by hand, but it is inelegant and detracts from Smartsheet, making it unnecessarily difficult to convince Accounts to pay for Smartsheet licences when Excel can do the job more easily ;-)
Thys