-
Adding a date
I am trying to add a date to a cell when that row is added. I have a row moving from another sheet, when it goes to the new sheet I would like it to record the date it was moved
-
Best way to pull data
Hello, I have a Master list detailing different department projects, and I use a template to create each project. I want to search the master and return information to the created project sheet. Is there a way to do this? Template: Master List Thanks, Shahara
-
% Complete Based on Child Conditions Met
Smartsheet Community: I Need to Add to The Formula Below to Calculate % Complete Only if it is a Pass, Fail, or Not Applicable. =ROUND(IF(COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()) > 0, COUNTIF(DESCENDANTS(), 1) / COUNT(DESCENDANTS()), 0) * 100, 0) + "%" Below is a Screen Shot of what I am Trying to Accomplish. Thanks
-
How to match 2 criteria ?
Hi, im trying to get some help to have a formula to have a summary of a questionnaire, based on a scoring sheet. So the formula will need to match 2 criteria: 1st criteria is to match the question number 2nd criteria is to match the response to the options to yield a target. i tried index/collect but i realise my 2nd…
-
Multiple IF Statements & VLOOKUPs in Formula
I am trying to populate a column, X, using IF and VLOOKUP functions on 3 unique columns but the formula only seems to be returning the correct value for 2 of the 3 columns. Background - Only one of the following 3 columns will ever be populated with a VP name. I'm using 3 different columns, one for each dept, as each dept…
-
Too many cells referenced - Need formula revision suggestion?
Hi, I hope some of you all had a great Engage. It was my first and very helpful. As soon as I got back, I started using DataTable to solve for a big problem I've been having with a voluminous sheet, but found that my formulas are still too referential ... according to the warning below. The TLDR is that I think my formulas…
-
Can I use a form with prioritization formulas?
Hi all! I am trying to come up with a more simple way to prioritize projects in my organization with one way to input a project. When a user wants to input a new project into the portfolio, they would use the form to select answers related to the project. When an answer is selected, it has a certain value and weight…
-
extracting text strings from a cell
This discussion was created from comments split from: Isolating all text to the right of a character (e.g. "-") in a string.
-
Get a status by needing 5 dates filled out
Hi, So i need a status column after the last date column here that says complete when all the dates are filled in or pending when only 1,2,3, or 4 dates are put in.
-
Update Request Email Notification - Limit fields to edit
I'm creating an email notification from a project plan to request updates for tasks that are in progress however the form allows editing of all fields on the selected rows of the plan and I only want the recipient to be able to edit one or two of the fields. However, they do need to see all of the fields on that row. Is…