-
Return a column value based on choice in Stage column (same sheet)
I know this is super simple, but I have spent hours with various formulas and can't get it to work. Any help would keep me from pulling the rest of my hair out. Thanks! Based on the choice selected in the Stage2 column ( choices are: identify, delivery, closing by May31, closed past 6mos, or closing), I want to pull a…
-
Embedded IF formula in NETDAYS
I am attempting to write a NETDAYS formula dependent on the input from a column on a sheet. I imagine I need to embed an IF formula, but I have had no luck in the format. Any help would be much appreciated.
-
Project template with task due dates based on final end date
Hello, We have a recurring event that happens 3-4x a year and all the tasks leading up to each event are the same. I'd like to create a template where I can enter the event date and it will calculate when the tasks are to be started based on a set number of days (i.e., 90 days prior to event start task xyz). I'd also like…
-
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…
-
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…
-
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…
-
% Parent Boxes checked
Hello, I need some help in creating a formula to calculate the % of parent boxes checked -see attachment. In this case I expect the answer to be 25% as only one of the 4 parent boxes is checked. Any help would be appreciated
-
% Time Elapsed Formula - Help breaking down and understanding long nested formula
Hi, I'd like help understanding the following formula that is being used in a sheet I inherited. I'd like to understand how to break down the formula to understand what exactly it is doing and how it is doing it. The formula is calculating "% Time Elapsed" based on Duration, Start Date and End Date.…
-
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…
-
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.