-
Push or pull a new cell value to other sheets
When a new project is created, a unique project ID is entered into a master project table/sheet. When that project ID is entered, I want to be able to automatically populate the project ID cell in two other sheets. Any direction and/or creative ideas are appreciated. Regards, Janet
-
Dropdown Selection Based on Previous Column Input
Hi there! I want to create two columns with the following features: Column #2: single select 3-choice dropdown (e.g., cat, dog, bird) Column #3: single select dropdown, but with three distinct dropdown menus, only one of which is available and is determined by what the user selects in column #2 (e.g., one menu…
-
Strange Formula Behavior
Greetings, I am developing a solution that automatically captures a 24-hour time (as an integer value) from the generated system date/time. The goal is to allow users to use a form on a tablet to enter a few fields of information into three sheets. My solution converts the times in each sheet correctly: Above is a portion…
-
MULTIPLE IF/OR
Is there a way to have an IF/OR statement for the following: Column A represents the initials of an internal contact at company. Column A is part of a sheet which has 300 rows. Column A could have initials KA, PP, or JM. I need a formula which will look at Column A, read which set of initials are present, and return a…
-
Trying to set up my Sheet Summary formulas so I can create a dashboard
I've been trying to set up my Sheet Summary formulas to look through one column, pick out the Not Completed projects and then take an average of the days outstanding. Not Complete Fx: =COUNTIFS(Contractor:Contractor, "BENTON Paving", Status:Status, "Not Complete") Unparseable Fx: =COUNTIFS(Contractor:Contractor, "BENTON…
-
How can I have a parent card marked as "Done" if all their sub-tasks are complete
We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't figure out how to have the parent row automatically mark complete. I used conditional…
-
Using "Contains" or Wildcard to search for duplicates
I am currently using COUNTIFS to find and flag duplicate persons by a match of both last and first name with this formula: =IF([Last Name]@row <> "", IF(COUNTIFS([Last Name]:[Last Name], =[Last Name]@row, [First Name]:[First Name], =[First Name]@row) > 1, 1), false) I want to change it so that it flags fields containing…
-
Export list of all users a smartsheet was "shared to"
I have been provided an export a list of who the smartsheet has been shared with an their particular permission such as view or editor. This is great because it provides that list of email addresses associated, however, it does not seem to provide the users name. Is there a way to export this information and include the…
-
How can I set a column to automatically select Yes or No based on other column criteria
If Submitted SC Form is Yes and Completed Training is Completed and SC Mailbox Status is Active than I need Completed All 3 Actions to select Yes, otherwise No if any of the three criteria are not met.
-
Smartsheet Checkbox
Hi there, I want to find a formula that works for the following conditions for a checkbox column. If no cells are checked enter "Not Started" If one or more cells are checked enter "In Progress" If all cells are checked enter "Complete". I need all three conditions to be included in a single formula.
