-
formula
HI all I am trying to create a formula and not having much luck, I am trying to work out a weighted total using a weighted figure which multiplies by a number in another cell but there are 14 other columns that need to do the same and add into the total so = row1 cell "data incorrect" * Row 9 + same formula for all the…
-
Change Predecessor Dependencies in Report
Dependencies in the predecessor column in reports are not viewable but I need some capability for users working from the report to update lag or lead days. If the row that is being viewed in the report is not the leading task in a line of dependent tasks, the user is only able to update duration (not the start date, finish…
-
Vlookup referencing formula field
I have a text/number field which is populating by using the =Left formula. I then want to reference this field using a vlookup to another sheet and pull in the corresponding information. I keep getting the #UNPARSEABLE error, and I've determined it's due to formatting, but not sure how to fix. As an example, I have a…
-
Formula based on two column values
Hi, I am looking at doing a formula that looks at two columns and provides a # value based on what on the values that are in the two columns This is a simple formula that I am looking at, but it will only go two levels down and then stops. =IF([Urgency Rating]@row = 1, IF([Importance Rating]@row = 1, "1", IF([Urgency…
-
If Checked then $$$$
Can some one help me with a if checked formula we are doing an intake sheet for a vendor showcase and i want the amount to create a total approved by each vendor when they select each option to show so like if column 1 checked then $10 and add a sum formula at the end I hope this make sense
-
Sheet Summary
I have a Requested Ship Date and I want to track the Month and Year that they were requested in a sheet summary. At some point I want to take that summary and put in on a Dashboard in a graph to show upper management the progress. is this possible? This is just a few month of the work I have an entire year that I would…
-
Average count by department of non-blank values
Hi, I have a sheet (produced from a template) for which the relevant fields look like this: The brown columns are just a visual aid to show where the weekends fell in this month (October), but potentially could have values in during other months. What I'm trying to accomplish is a rounded (up) average count of non-blank…
-
Pre-Completion of a Form from another sheet
Hi I've got a couple of sheets that work together. On the first, I enter the basic details and then send a request to a manager that has the link to a form on the second sheet with a number of fields pre-completed with the data from the first sheet. They then complete all the other required fields. It works just as I want…
-
How can I average a percentage in a parent row?
I have a status column that uses Red, Yellow, Green and Gray to represent "Not Complete", "Partially Complete", "Complete" and "Not Applicable". I successfully added a progress column that uses a formula to translate those statuses into a percentage. However, since the parent row also has a status color, I can't get the…
-
Is it possible to use the LEFT function across multiple columns?
I am building a UAT smartsheet that is working really well. However, i want to calculate the tests performed using the test reference i have created for each test. I have successfully used this formula for a single column, BUT need to have it work across multiple columns, does anyone know if this can be done, and if so,…
