-
Using IF -> Cell Reference -> OR
Hey folks, Basically I'm trying to put a cell reference in between two logical statements. In this case, if either "Person A" or "Person B" are in the cell, return "Team A". Here's my formula: =IF([Assignee Contact]@row = (OR("Person A", "Person B")), "Team A", "N/A") I can't find anyone indicating that this is even…
-
COUNTIFS 4 variables
Hi, I need help with this formula. As you can see I am hoping to count when the name: Category Management is found in FUNCTION 100% is found in PERCENT COMPLETE S-CL is found in PERIOD and Day 1 is found in PERIOD Goal is that if all attributes are found, the count and provide a total. My formula is below.…
-
Make on weekend as working days
I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days. I appreciate your help
-
Checkbox & Pulling back values in a cell
Hi, I've done my research and it looks like people have had to use Zapier for this specific use, but want to throw it out there again before i go that route! I am looking to pull back a value from a row where a box was checked. So i am thinking that in my formula sheet i can create a formula that basically says 'if the box…
-
Averaging numbers that meet a defined criteria
I'm creating a metrics sheet to feed a dashboard. On this sheet I am referencing a different sheet with the data. The formula I need to create would do the following: 1) AVERAGE the numerical values in one column. 2) IF the data was collected in a certain month, which is identified in a different column. So for example, I…
-
Regrouping Delimited Data
I pull data from an internal system and add it to Smartsheet via Data Uploader. When it comes in, it looks like the above, with Biz Entity, Sub Business Entity and Product Family grouped as delimited data. However, I want to regroup it so that each Biz Entity/Sub Business Entity/Product Family group is together in a single…
-
Help with MAX Function
Hello, I need help writing a MAX formula to return information by the latest creation date. My current formula is =IFERROR(INDEX({CS PT Recruitment Candidate FirstName}, MATCH([Workday PID]@row, {CS PT Recruitment PID}, 0)), ""). If we recruit for a position multiple times in a fiscal year, the position ID remains the same…
-
Can I include a date from another sheet into a formula for my current sheet?
Hello. I'm pretty new to Smartsheet and can't find an answer to today's dilemma. For example, I have a two sheets: ABC Project (belongs to me) and XYZ Project (belongs to our vendor) I want to be able to calculate a start date on one of my tasks in ABC Project by pulling a finish date from XYZ Project? Basically like this:…
-
Count between ranges
Reaching out to see if my formula, which seems to be working, is the correct way to COUNT between two ranges. In my example - I want to count a category name AND only if the % Complete range is between 25% - 49% FORMULA =COUNTIFS({Function}, "Asset Protection", {Percent}, >0.25, {Percent}, <=0.49) As mentioned this seems…
-
Using Contents from one Date cell to update another Date cell
Im trying to use a 'helper column' to run a formula that checks the contents of a date column/cell, and copies those contents to another date column/cell. The code I'm using is quite simple, so I feel that I must be making a silly error, or it is not possible. To re-iterate, I have a cell specific date column , and I want…