-
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!
-
Custom Auto Numbering Function
Hi! New Smartsheet user here, appreciate any help and guidance. I'm looking to create a formula to build a custom auto-number function. I'm including a screenshot for reference. I'd like to automate the Project ID column. Where the project ID is YEAR - CLIENT - CLIENT PROJECT NUMBER. Is there a formula out there that would…