-
The sheets of the workspaces I own are deleted by themselves every day
Good morning, greetings. Since I renewed the license, the sheets of the workspaces I own are deleted by themselves every day, please how can I solve this problem?
-
Form Validation - Phone Number Default to Canada?
Thought I would ask here before contacting Smartsheet Support (as I'm hoping someone else has had this problem, and has a resolution). I've built my form, and added 'Phone' as the Validation. The problem I'm facing, is that I've changed the default to Canada (on the 'Field'; right hand side), but it continues to appear as…
-
Collect most recent date from another sheet based on certain criteria
Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a quick reference to see the most recent service per vehicle per category. Being multiple services will but under a category I…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Every time i want to make changes on my report it gives this pop up dont know what is happening
-
How to only Sum values for unique requests with a specific request type
Hello, I have created a sheet to calculate some data points based off of an archive of requests that get pulled from an Automation when Estimated Completion Date and Actual Completion Date are changed, and I am trying to setup a columns to display the Average Days to Completion for each request type to help with estimates…
-
Formula to compare 2 cells and generate the difference on a 3rd cell
Hello all, I am working on a trainings tracker for our project team, and I am a bit stuck. I need to generate a formula that will compare the trainings that are listed in the Required and Completed column cells, and generate the difference on the Outstanding column. Any suggestions would be greatly appreciated!
-
Require a number format
Is there a way to force input in a form to be in a specific number format? For example, require that a customer number be 10 digits, or an account number be XXXXXX-XXX?
-
Roll up based on selection from one column and count of answers across mulitple columns
I created a form to get feedback from 6 different business units regarding 48 different applications. The participants select their business unit name from a single select dropdown. They then rank each application as “Not Used By Myself or My Team”, “I'm Not Sure”, “Not Important”, “A Little Important”, “Somewhat…
