-
AVGW Formula with Conditions
Smartsheet Community: Does anyone know how I can get Average Weigh Only if Criteria is Met? For Example I want the AVGW if The Status is Open or Potential. Current Formula without Criteria: =AVGW([Risk Score]:[Risk Score], [Schedule Impact]:[Schedule Impact]) Thanks
-
vlookup/index across 2 different sheets
Hi everyone, I am trying to build out a workflow between two smart sheets - Our end goal is to have a user select from a drop-down list of numbers which once selected will then populate across the columns in the sheet. The sheet with the master data it would be referencing has the same column headers, the challenge I am…
-
How to index using more than one row_index
So I am working on making a list of the successors assignees, so that smartsheet can notify people once the predecessor tasks have been done, I have pulled the list of successors using the formula =JOIN(SUCCESSORS([Task Name]@row), ", ") and to find the corresponding person to that row I use =INDEX([Assigned To]:[Assigned…
-
Merge and Center
I need to merge and center a specific cell in this smartsheet without modifying the original column size For example, in the photos, the cells that have text need to be elongated, but the percentage cells can be reduced in size. can anybody help me?
-
Sumifs formula only works on one row
Good Afternoon, I am trying to use sumifs to calculate total number vacations days a person has referencing another sheet. The formula works for one person but not any other names. Here is the formula: =SUMIFS({Team Vacation Planner Range 2}, {Team Vacation Planner Range 3}, Employee@row, {Team Vacation Planner Range 4},…
-
#Blocked Question
Good afternoon. Any help would be appreciated. I have a master sheet with a parent row that has multiple subsections. Please see below screen shot. One row of the subsection reports the DG REM. I have made a column separate from the parent row which I have tied to the DG REM. So when input the DG REM it immediately ties to…
-
When cell from a row is marked as completed I want a second cell in same row to fill todays date
Hey all, I'm trying to find a way to automate some metric tracking system. I've got a sheet that one of the rows has status updates and another that has completed date. When a cell is marked status for completed I want the completed date to automatically populate with the date that status is changed. Is there a formula to…
-
Enhancement Request - Multiple Rows From a Single Form Submission - Multiple Lines
Having the ability to create multiple line item entries on a single form. Meaning, let's say you create "header" information 1x on a form, but then enter multiple Line Items (which end up as separate rows) rather than having them extend into multiple columns. Data is not user friendly by any means in this current format,…
-
Extract the first word from a cell
Hi, In 1 column I have a string that has 1 word then 2 or more words after that, how do I extract from the column the first word only? In excel I'd use the following =TRIM(LEFT(A2, FIND("^",SUBSTITUTE(A2, " ", "^",1)&"^"))) In Smartsheet there's no TRIM.. The below formula returns the value of the first and second word,…
-
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…