-
Trying to get the number of instances of a value from a column with a dropdown list property
I have a field (column) in my source sheet named [Hub/Site CLLI]@row that I need to find the number of instances contained in a drop down list named {Tinas node_comparison - All CLLIs} in the target sheet. When found I need to count the number of instances of the "NTODAANODE Ticket #" found in the target sheet. This is…
-
Check a Box if Values Greater than 2 appear in any cell in a row
I've seen many posts about box check =IF formulas, but they all reference specific columns in brackets. Is there a formula I could use @row that would search the entire row for numbers greater than 2 and check a box if there is a number greater than 2? Thank you! This helps flag when the workforce has been overscheduled.
-
Formula Help! INDEX(COLLECT)
I have two sheets and two columns i am trying to compare: 1) Finished Lot Inventory Summary Column Name: Development Column Name: Lot Number Column Name: Finished Lot Inventory Count 2) Starts Schedule Column Name: Subdivision Column Name: Lot Column Name: Notify On the 'Starts Schedule' sheet, I am trying to populate the…
-
Formula Help for Allocation % of work week based on employment type
Hi - I'm trying to figure out if I can put an automated column into Smartsheet. I think that I might need to use a couple formulas, maybe in multiple columns, but for the life of me I just can't figure out how to make it work. My manager asked me to list out percent of workweek allocation, based on different work types. I…
-
Column Formula for a future date, 3 months before annual start date
Hello everyone, I have a column formula that creates a date in the future based on [Start Date] while simultaneously avoiding child rows: =IF(AND(Hierarchy@row = 0), IF(MONTH([Start Date]@row) >3, DATE(YEAR([Start Date]@row) +1, MONTH([Start Date]@row) -3, DAY([Start Date]@row)), DATE(YEAR([Start Date]@row), 12 +…
-
SUMIF(S), AND, IF, Checkbox formula functions
Hi brainstrust, I am trying to build a resource conflict formula(s) that deliver the end results of: If a project row has overlapping dates AND has the same resource type(s) selected (different columns with check boxes) as the date-conflict project rows, return a "conflict" result. AND If a project has a resource type(s)…
-
ACOS Function does not exist
Hello, I have created a Smartsheet to collect operations data and I'm now trying to add a formula in there to automatically return a result using a formula. In other words, cell B1 and C1 get filled out through a form, and when that happens I want D1 to show a result using a formula which includes ACOS (Arccosine) and SQRT…
-
Row referencing while cross-referencing sheets
This is my current formula in order to input the proper value from my master sheet. I am trying to change it so that I can drag the formula down (similar to Excel) and have the value of 1 update to 2 and so on. From what I have read it seems that the @row function is the answer to this problem but when I use the equation…
-
CountIF Series of Checkboxes, up to last unchecked box
Hello, I have a sheet with a series of 6 check boxes for different tasks. A team-member checks a box when an operation/task is complete. Some tasks can be done concurrently and are not dependent on another, but I would like to indicate the last completed task up until the next blank check box. Example 1: Checkboxes 1-4 are…
-
Return latest value, by date, if criteria match
My brain is absolutely melting over this one. I'm not sure if what I'm looking for is too involved, or if I am just truly not understanding how to piece these formulas together (the latter is 100% likely the case). I'm looking to do the following in a Summary field: Step 1: Return the latest value from Supplier based on…
