-
I fixed my issue but why? - Notification email delayed by 1 day
I have a sheet that notifies people when they need to review a document based on when it reaches its expiration date. The idea is that people are sent an email notification 90 days, 60/30, and 7 days before it expires so they can take action. I have the date the document expires in one column and in another column, I have…
-
Row height problem
Hello! I have looked through a lot of searches, and cannot seem to see a resolution to this problem. Sorry in advance if I'm missing something easy! I have a sheet that allows an input word in the yellow box to search another sheet. Looks like this before entry: As soon as you enter a word, and hit enter, it uses a formula…
-
Stock Market Data
Hello Everyone, Wondering if anyone has created a sheet that pulls stock market data (share price, market cap, etc.) directly from the internet. Thanks for your help. Shawn
-
FORMULA TO PRESENT THE MONTH (NAME) IN A CELL
I created a formula using -MONTH to extract the Month Number, but i want that number to convert to the name (JAN, FEB, etc) I started with pulling the Month Number from the Intake Date column; =MONTH([Intake Date - \[Select Date\]]@row) then, I used an =IF to convert the "1" to equal JAN: =IF(Month1 = "1", "JAN") I thought…
-
COUNTIFS & CONTAINS (cross sheets)
Trying to count following: Any row on reference sheet in the YEAR column that is equal to "2025", CONTENT TYPE ="US" (dropdown column, single select), TEAM = "EU4" (dropdown column, single select), CRITERIA column contains "Pan-EU" (dropdown column). I have tried everything and works fine until I use Contains. I get…
-
VLOOKUP to another sheet - cannot pull these fields into a report, getting #ERROR
I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue where the report can only successfully pull data in sometimes. Sometimes I open the…
-
If Error to fix "Invalid Column Value"
What's the formula for fixing Invalid column types? Specific example: I have a text/number column for info from another sheet; one cell is a date and I'm getting the "Invalid Column Value" error. Smartsheet suggests this help article And gives the example of this for a text/number =MAX([Due Date]1, [Due Date]52) with this…
-
Auto Generating a Sequential Document Number Based on Cell Criteria
What formula can I use to auto-generate a sequential number into the Document Number column for each row based on the information placed in Company, Department, and Type? I need the numbers to look like this: PBI-ACT-FRM-0001. "Company-Department-Type-Sequential Number" We have several Department and Type options in a…
-
Combining COUNTIFS formulas
Currently I have two COUNTIF formulas in two different cells, then I am using a 3rd cell to add them together. I am looking for a way to combine the formulas and have everything calculated in one cell. Both formulas are pulling data from different sheets. 1st formula: =COUNTIF({B2B Thermo Fisher Project List Range 1},…
-
CountIf Function
I want to count the number of each option in this example; Change Router, Upgrade, Disconnect. My Objective column is set up as a drop down with allow multiple values enabled. My formula is only calculating Row 5, because that is the only row with only one value. How do I get my formula to calculate each drop down option…
