-
Prevent Unintended Changes by Disabling Removal of Logic when renaming dropdown items
I was editing the value fields within the column. One of the dropdown answer choices was “New Request”. I simply just added a new word “New/Continuation Request”. When I added the new word, that’s when I found all of the associated logic removed. I never removed a field so in theory, the associated logic shouldn’t have…
-
"copy row to another sheet" - Sometimes row gets copied down at the bottom?
Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must be sensing that the rows in-between are not empty, but does anyone know what causes…
-
How can I change non-working days for all sheets in my account
It seems pointless to set non-working days as a default within the Admin Console and/or sheet since changes don't seem to apply to any sheets unless they are brand new. None of my existing project sheets reflect changes - templates seem to inherit whatever was in the settings at the time the template was created. Please…
-
Autocomplete text cell like in Excel
Found only one comment about this feature from a couple years ago, and I can't believe it's not been implemented or not in demand. I know autocomplete works for a dropdown, but I'm using Smartsheet as a sort of workorder management system, and the client has way too many customers and adds customers too frequently to keep…
-
Multiplication Formula
Hi, I have two columns 'Likelihood' and 'Current Maximum Impact'. All I want to do is multiply them together, can anyone help please? Thanks
-
What is the "Last Modified Date/Time" column referencing in the Sheet Access Report?
From what I can tell, it's not reporting the last date the sheet was opened or edited, because I have a sheet that is used daily that's reported as last modified 7 years ago. Is this referencing the last time the sheet's structure was modified? If so, it's not very useful for helping identify underutilized or unused…
-
Basic copy/paste function
I don't understand why the simple copy/paste function of Smartsheet doesn't seem to work without going into a cell. For example, if you're trying to copy a number of cells (name, email address, request ID) to be used either in Smartsheet or notepad, you'll get the functionality via Cntl+c or right click ->copy. The data…
-
I am not receiving any notifications from smartsheet and in email
Hi, I am not receiving any notifications from smartsheet and in email even if I am making changes. Before when I made a change the smartsheet automatically send notification. Please help. Thank you Regards, Jeremy
-
Update Requests - Displaying (via Reports or Dashboard)
Does anyone know if there's a way to Display Pending Update Requests? We're using a lot of automation to send out Update Requests to team members, and I'm concerned that they're going to get lost in emails. It would be great if I could build a report, dashboard, etc. that showed all the Pending Update Requests. Mike
-
Convert drop down in text format to date format
I have seen various other questions in the community, but I can't quite get my equation there, I am trying to convert a drop down from a form to a date in the adjacent column. All dropdown items are formatted as follows: 7/07/20 Here is what I am trying: =DATE(VALUE("20" + RIGHT([Testing Date]@row, 6, 7)),…
