-
Approval: two users/same level
Hello, Is there a way I can send an approval form to two managers who both need to sign off on each staff member's annual leave? I can do it if I send to Manager A first and then Manager B once the first step has been completed, but wondered if there's a way to do them both at the same time that I'm not seeing...?
-
Table of contents in a large sheet; use of forms
hi, I use one large sheet to manage many different legal tasks across my team (1,000 rows currently). The sheet is divided to many sub sections/categories, main tasks, sub tasks etc. Wanting to add a new main task to a category, the user needs to scroll down to find the right category which is time consuming. Two questions…
-
Unrecognized System Contacts
I'm seeing behavior in a sheet that I'm not sure if this expected or not. I am a known contact in our corporate instance of Smartsheet. The screenshot displays content in a sheet column that is created by submission of a form. For this particular column, it's populated from an email address in the form field. Submitters of…
-
Remove Mouse hover over pop up tool tips on menu bar ribbon
Is there an option to remove the pop-up mouse hover tool tips on the top menu bar ribbon? It is getting in the way of the feature buttons and has become very annoying. Thank you!
-
Multilevel Collect/Sumifs Formula Difficulty
I am attempting to parse a large amount of sheets together and have hit a snag in a formula. My data looks like below: H | A | B | C 1 | 7 | 4 | 9 0 | 2 | 1 | 5 1 | 5 | 3 | 1 H is a helper column displaying a 1 if the data should be utilized and a 0 if not. I need to reference a range as a whole in order to keep my number…
-
Milestone Tracking Report - Numerous projects
Hi all I'm trying to create a status report which would roll up project tasks and their progress into an easily view-able report and/or widget The data will be across multiple sheets and I'm trying to find a way to trigger both active, complete and in progress data sets so that I can target the relevant stages inside of…
-
Is the Parent Row expanded?
Is there a way to know if a parent row is expanded (that is the + sign was clicked and the children are visible)? For example, my sheet contains 3 rows that are parents (Orders 1, 2, and 3 below) each representing a different order. The children of each parent is an item in that order. For sake of discussion and…
-
Scrolling with a mouse wheel
This is a minor thing but trying to figure out how to scroll up and down in my sheets using the wheel on my mouse. This works in every other piece of software I use but in a Smartsheet I have to use the slider bar on the side to move up and down through a sheet.
-
Automation Using Dates to Generate Reminders
Hi Everyone, New to Smartsheet so sorry for the rudimentary question. I'm having trouble getting automation to do what I want it to. I have a project sheet with multiple tasks with various due dates. I'm trying to send reminders prior to the due date. I do the following: Trigger: Run Once: On: Date Field: Due Date: 9:00AM…
-
Referencing a Column in Another Sheet
I am having trouble referencing a Column in another sheet through an IF formula I am trying to do. My current formulas is =IF({Sheet 1 Range 1} = 1, {Sheet 2 Range 2}). The first Column I am referencing is a Checkbox Column, and I only want it to return the value in Range 2 unless Range 1 is Checked. Whenever I do this…