-
SUMIFS with External reference to a single select dropdown
Hi, My apologies for my lack of brevity, I'm not even sure how to word or ask a question about this... I am obviously pretty new to Smartsheet. Objective: To be able to flag projects where the assigned resources don't have a lot of experience with the specific project type. Context: I created a sheet (SHEET A) that's…
-
Day counts
Hello, I am working on formulas to gather our end date/past end dates for example I want to capture 45-day, 30-day, 15-day, 10-day and 5-day I do not care if it is in a pie or metrics just not sure the best way to gather the data with there already being a formula in the column to calculate those days then present them on…
-
If Function
I've tried everything. I'm sure it's a simple fix. If Type = New, then Store Open Date needs to be OPS T/O + 4 days If Type= Remodel, then Store Open Date needs to be OPS T/O + 2 days. HELP! Please. Thank you. =IF((Type@row="New"), ([OPS T/O]@row+4), (Type@row="Remodel")([OPS T/O]@row+2))
-
Why am I observing this odd behavior with a "Created (Date)" column?
I think I've found a bug. I have a column that is of type "Created (Date)" called "Date" and another column called "DATE TEXT" which is a text column. DATE TEXT = Date + "" DATE TEXT is calculated by appending a null string to Date. I have noticed erratic behavior in another sheet that references this column, and I believe…
-
Nest IF Statement
Hello, I could sure use your help. I have multiple nested IF statements that I cannot seem to get to work correctly. Here is what I am trying to achieve: IF Date is Blank, Leave the cell blank IF MONTH = 1, return Jan IF MONTH = 2, return Feb, etc, etc. I can get the blank part to work but it won't seem to go past that to…
-
Cross Sheet Formula to list children in separate cells
Im creating an agenda sheet template where people can plug in a parent SKU, and then if there is children it auto populates all the children SKU underneath it, each child in its own cell/row. I can get it working manually adjusting formulas, but was hoping to get a more user friendly version that people can drag the…
-
Formula Index/Match -has any of
Hi is there a way to create a formula that will match to 'has any of' instead of an exact Match? Here is my current formula: =INDEX({Look Up Table Range 1}, MATCH([Sold To Name]@row, {Look Up Table Range 2}, 0)) If my look up table has the name "TEST 12345" I would like my formula to still pick up "TEST" and populate -so…
-
Info in email alert not same as on smartsheet
Good morning, I created a Smartsheet for employee anniversaries. The formulas and automations are all working perfectly, there's just one strange thing that is happening. In my Smartsheet, I have a formula to calculate the anniversary number which works great, however, the anniversary number doesn't always translate to the…
-
Need help with formula to alert when Actual Progress is behind Projected Progress
Hello I have been trying to nail this down for the past couple of weeks but falling short. I need a column that shows Red, Green, or Yellow based on Actual % Complete vs Projected % Complete. I am calling it Progress Alert. I need it to show the following: If Actual % Complete is 25%+ behind Projected % Complete show Red…
-
If function
Hello, I'm happing trouble getting an if function correct as it keeps returning #unparseable. I have a nested if function in a contact type column. Depending on the value in the Service column of a row, it would return a specific email address. I have pasted the formula below although I've changed the email addresses for…
