-
I need of the proper formula to calculate percentage.
I have two columns, an Open Proposals column and a Proposed closed column. I need a formula that will calculate at what percentage our close ratio is. I would be grateful for any help someone may take out of their day to help. Thank you!
-
Ranking Entries
I have a scoring smartsheet where we are ranking applicants based on a score. I would like to set up a column that automatically ranks them BASED on how high or low a number is in another column. ex: Column 1, Column 2, Column 3 - all scores Column 4 - Formula entered to automatically give me the total of Columns 1-3…
-
I'm trying to create a formula based on a drop-down list and corresponding columns.
I am trying to build a formula that uses a drop-down list that corresponds to different columns, it needs to capture all of the options. I was using an index match but I can only get one variable to pull and it's not pulling the correct date? A column with Current Phase has multiple drop down options that I need to match…
-
TOTALFLOAT returns #INVALID VALUE
Hi, I'm trying to use the TOTALFLOAT function to find the slack in my schedule from the critical path. I have dependencies enabled. The formula is =TOTALFLOAT([Task Name]@row). Task Name is my primary column. However, it won't return a value, just the #INVALID VALUE error. I baselined my schedule already but it shouldn't…
-
how to leave the optional rows out, so they don't impact the parent row completion rate
Hi Community, As displayed in the picture, we don't need any actions of the optional rows for now, but i feel like it impacts the completion rate of the parent row. The formula of the completion rate is embedded in Smartsheet , I don't think I can't change it, show as picture 2. Is there a way to make those optional rows…
-
Can the Yearday function be used to identify all day numbers for a range of numbers?
Hello, My primary challenge is that I'm trying to use legacy Smartsheet functionality in place of Smartsheets Resource Management functionality. So, I have a project plan created in Smartsheet and I am trying to evenly distribute the Hours per task across the Duration (start and finish dates), because I want to create a…
-
Need Help with JOIN(COLLECT with HAS
I can get it display the Status in the Predecessor Status column when there is a single Predecessor, but not display multiple Status values when there are multiple Predecessors. =IF(Predecessors@row <> "", JOIN(COLLECT(Status:Status, RowID:RowID, HAS(Predecessors@row, @cell)), CHAR(10)))
-
INDEX/MATCH formula broken after number passed 100
I have been using an INDEX/MATCH formula to identify entries from one sheet to another. I used an automatic numbering system starting at 000 to index/match. If there is no match, then the formula returns a blank cell. Entry # 100 was deleted out of the sheet due to an error and after that the INDEX/MATCH is no longer…
-
Need Help with Modifying an IF/OR Statement to add an AND condition
I have a column I recently created in a sheet to help our team know if they are missing information in a critical field before they move on to approvals (Critical Fields). I used an IF / OR statement to look at all of the critical fields and determine if any of them are empty. If one is empty then the field (checkbox) will…
-
Concatenate Names Based on Two Factors
Hello, I'm trying to pull a list of names from a sheet based on two factors. In sheet one I need to match if a value is in a column, to use the vendor name from the column and match the vendor name in sheet 2, to pull every name assigned. Sheet 1: If Needs Review is greater than 0, then find vendor name, and match to…