-
Should I use IF or IF(AND....or Something Else?
Good afternoon everyone. I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or…
-
When saving as new, I want to break links including sumifs but I'm having an issue
I have a sheet that's linked into a pivot sheet via a series of sumif cross sheet formulae. This sheet is looking into the pivot sheet at a point in time e.g. month of April YTD information, and the Pivot will update monthly as new data is uploaded to the source report (I will also need the new data but the historical data…
-
IF Checked, Assign Auto Number
Hi there! I'm no excel or Smartsheet formula wiz but I'm hoping someone here can help me figure out a way to do the following: I'd like an auto-populated number to appear in a row when the "Estimate" box is checked. There will be some rows where estimate is not checked and therefore I don't want to dedicate a row to a…
-
SUMIFS with date: count within the last 7 days
I'm looking to count the number of punches at various rec centers within the last 7 days. Rec centers have dropdowns with locations. Punches is a numeric value with a daily total. Each center has a daily total. I have a separate sheet for calculations. I'm looking for a formula related to each center to count the number of…
-
VLOOKUP Help
I'm trying to write a formula in my driver sheet that will search for an employee ID number in the completion sheet and return the text from a column within the completion sheet. I wrote the following but it returns a #NOMATCH value if the employee ID is not listed in the completion sheet. I'd also like for it to return a…
-
Can you use 2 joins in the same formula
IF Type = Project join Type+ID+"-"+PMO Project Name If Type = Request join Type+ID+"-"+Request Name I've tried this a couple of ways - if I select Request - it comes up as Request1000-RequestName If I select Request then it blanks out. instead of Project1000-ProjectName Formula =IF(Type@row = "Rqst", JOIN(Type@row + [Rqst…
-
How to use MONTH(sheetrefencerange) in a SUMIFS function?
I cannot get the function below to calculate correctly. I keep getting 0 for the sum. =SUMIFS({Hours}, {Input Date}, MONTH({Input Date}) = 4, {Project ID}, [Column2]@row) {Input Date} is a column reference range in another Smartsheet. {Input Date} is an auto-generated date/time column.
-
Formula Help: Combining Checking a Box with a % Complete to Return a Status Ball
I'm having a hard time combining a formula that when I check off the "Done" checkbox it turns the % Complete to %100 and also changes the health to green as well as combining the criteria of this formula: =IF([% Complete]12 < 0.5, "Red", IF([% Complete]12 < 1, "Yellow", "Green")) Is this possible?
-
Best formula to return a list of qualifications for card view
Hi Community, So, I am trying to save myself a lot of manual data entry. Ultimately, I am trying to take a spreadsheet that was created in Excel, to capture each persons "qualifications" in a specific field, and get it into card view. I have attached the files of what I am starting with and what I would like to end up…
-
Date not recognized in column
I have data coming into Smartsheet from a Microsoft Form, and I'm not sure how to get smartsheet to recognize the data as a date. I tried to create an additional Date column, and putting in a formula to copy the date from the original column (hoping that the settings of the new date column would make the data officially a…