-
Cut not working
Starting 7/30/18 we noticed that using either the keyboard shortcut or the right-click option to cut a line within a SmartSheet would sometimes leave behind the original line (acting more like copy than cut) when moving to a different place in the SmartSheet. Two people within our organization have recreated the problem.…
-
Prefill Form with a Date Column
Hey Smartsheets Community! I can't find any information on this so I'm hoping y'all can help! We are making a panel application form and we're attempting to make a form that will fill with pre-arranged dates but only allow for a single selection of said dates. When someone selects a date in the smartsheets form, we would…
-
How to re check many attachment file? When I backup data from Smartsheet.
Hi, When I do backup of my Smartsheets, all of my files that were attached to any rows are saved to a separate folder. That's fine, but my problem is, I don't know which rows those files were attached to. I need to find a way of linking files to the original rows that the files were attached to. please help me.
-
Cross reference error
Hi there I have created a cross reference with another sheet and named the ranges as well. It works fine for few days and then after few days it shows invalid ref error Again i have to re refere the ranges in the formula and it works fine for few days. Please help me and guide, what i have been doing wrong. Kind Regards…
-
Don't include parent rows in checkbox complete roll-up percentage
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND the total % complete. We use parent rows as headers that should not be included in this total. I had a formula that sort of…
-
Nested SUMIF formulas across multiple sheets
I am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this doc "Hourly Jobs Breakdown". (Rates will all be in $00.00 format, I just forgot to…
-
Populating Drop Down list from column of entries in another sheet
I would like to set up a single call log, where I could put information into a sheet that would have a cell with a pull down that would populate with unique client names (or ID's) from a column in another sheet. So, when I put a log entry in, I could have a list of clients to choose from. The next step, would be to post…
-
Link row cells (several at the time) from the resource sheet into a column on the destination sheet
How can I link a group of cells on a row to populate in a column ? Resource sheet Destination sheet (ignore the numbers)
-
Multiple selection on a drop down list
Hi, I read in another tread that the ability to select multiple items in a dropdown list was in development. Does anyone know if that is available now?
-
Issue with Other Sheet References
Is anyone else having issues building multiple other sheet references? It keeps backing out of the formula box when I finalize the reference. It seems to make the reference alright, but I have to type it in instead of the reference going where it should. This has always been somewhat glitchy but it seems a lot worse for me…
