-
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)),…
-
Dynamic View - Dropdown Lists
I have certain single and multiple select list columns that do not have the "restrict to dropdown values only" checked on the source sheet but in Dynamic View we are unable to add in our own values if they don't exist in the dropdown. This has been extremely frustrating especially when trying to capture new values and…
-
Looks & format of automated emails
Hello, I would like to use automated emails & reminders for client-facing communication. But the amount of irrelevant information enclosed is a problem. Are there currently solutions to any of these? 1- Unnecessary header that has a Log In button next to it which confuses external contacts who do "NOT" need to get into the…