-
Count 1, 2, 3 etc from a specific point in a column and then restart for replicated parent row
Hello community, I would like a formula that creates a string of numbers starting at 1 every time I reach a new set of children in a row, but also skipping any group that has the name accessories or rack. I only want to count (starting from 1 each time) for the group that is "Equipment Master List" with the parent being…
-
Look for matching fields in multiple Smartsheet's and return an adjacent field.
I have an ID number that can be located in one of multiple Smartsheet's. I would like to look for and match this ID number and return a field from the same row from whichever Smartsheet (SS)matches the ID number. I have multiple formulas that allow me to find the matching ID# from only one SS: 1) =VLOOKUP([AIE-ID#]@row,…
-
Auto Populate field based on selection
Good morning everyone! i am hoping you can please assist me. I am trying to create a form that if a person selects a name their position auto populates. Can anyone help me with this? Peppey
-
Can anyone please explain why my Mid formula is not working?
I am trying to pull the 5 digit number ID in the middle of this text string. My formula works for the ones labled CTV however for everything else it is an #Incorrect Argument. Any help would be greatly appreciated =IFERROR(MID([Campaign Name]@row, FIND("_CTV", [Campaign Name]@row) - 5, 5), MID([Campaign Name]@row,…
-
How to check if cell contains one thing or another?
Hi all, I'm making a sheet that references another sheet to get data for a detailed graph. I'm trying to count the total number of small, medium, and large projects. The formula I have that works for individual campuses is as follows: =COUNTIFS({Size}, CONTAINS("Small", @cell), {Campus}, CONTAINS("Example", @cell), {In…
-
Formula to Count a value and create Sequence number stops and repeats
In an source sheet we have list of countries. If India is twice and in destination sheet it is 6 times but the value I need it in sequence i.e., 1,2 and starts again from 1,2 and again 1,2. US is at 3 times in souce hence in destination sheet 1,2,3 and repeats.
-
Full a rating from one sheet to another
Hello, I am using the below to pull a rating from one sheet to another. I want the two sheets to look a the staff name, and then pull the rating over. Example: Master sheet has Joe Smith (Full Name Team) with a rating of Far Exceeds Expectations. I need this rating to go into another sheet (just that cell) where I have Joe…
-
Duration Including Weekends
Hello! We have our project (task tracker) set to exclude weekends, which is what we need as we don't want anything due on the weekend. However, we need a duration column that includes all days between the start and end date, not just the business days. How can I do this? It's currently showing the duration of business days…
-
Float between task and it's successor
Hi, There doesn't seem to be any clear way to calculate the float between two tasks. If I have task A and task B, and task A is a predecessor to task B, I'm looking for a formula to calculate the amount of time task A can be delayed. Has anyone found a method to do this? TOTALFLOAT is not useful on my projects, it often…
-
Count if a cell has two values
I'm trying to count if a cell has the values of either 'Yes' or 'No' but am getting an 'Unparseable' error. =COUNTIF([Description Format(correct format)]:[Description Format(correct format)],OR(@cell=“Yes”,@cell=“No”)) Help! Thanks in advance!