-
UNPARSEABLE IF AND MAX FORMULA HELP
Hi Community, Can you tell me what is wrong with this formula? If the automatically populated created date is Max it returns 1 if not 0. =IF(Created@row ={MAX}Created:Created),1,0)
-
Return several values via a vlookup
Hello all, is it possible in smarsheet to use a vlookup that would return several values in the same cell. I have a sheet with the list of users and the departments they belong to. I then have a sheet with the tasks of a project with a column that contains the users in charge of a task, each cell allows the addition of one…
-
Changing Status and Health Based on Percentage
Hi guys! I'm fairly new to Smartsheets (and project management) and i'm the first and only project manager at my company. I was looking for help with conditional formatting and and IF AND function. Any and all help would be greatly appreciated! What I'm looking to do is (seemingly) basic: If my "Percentage Completed" row…
-
IF(JOIN(COLLECT())) issues
Hello, I have the below formula working correctly and returning the Rally Status if the User Story field has one User Story in it. Unfortunately, I need it to return all the status separated by a delimiter of ", ". For example, 'US1234567, US1234568, US1234569', I need to return status like, 'In Progress, Closed,…
-
Sheet Summary Won't Count # of Cells with %
Hello, I have a sheet that has a column for % complete and I cannot get the formula in my sheet summary to count the # of cells that are 25%, 50%, 75% or 100% complete. The formula I'm using is =COUNTIF(Percent:Percent, "25"). This seems to work to count any that are 0% but none of the other numbers. What am I doing wrong?
-
Countifs with date criteria and also parsing drop down
Hi all, Been struggling on a formula for too long. Need some assistance from some of the great minds. I have taking information from a sheet and trying to count the amount of times a condition is met within a specific time frame. Here is my current formula: =COUNTIFS({IC Issue Tracker Range 7}, @cell >= DATE(2023, 2, 20),…
-
VLOOKUP with more than one contact
I need a formula that when a job is booked in, will check to see if team members assigned to it have liability insurance. I have a separate sheet (Certificates v2.0) with our workers listed and whether their liability is Current or Expired. The following formula works but only when there is a single team member in the Team…
-
Copy a certain columns to a new sheet as new rows are submitted
I have a master sheet that contains information submitted via a form. I am wanting to have a new sheet that contains only certain columns of information that populate as the data on the master sheet is entered. I only need specific columns of information, not every column in the row on the master sheet. Any ideas on how to…
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
-
Looking to compare two dates to create an Integer value across sheets
Hello, I am looking to create a tracker that tells me the quantity of samples that arrived in the estimated time against the actual time. My thought process was you have two date columns Date Column A (estimated date) and Date Column B (actual date). I would in my raw data sheet create a link to Column B first than compare…