-
Count Days down to a due date
If I have a "Due Date" column, and I want another column to calculate the amount of days leading up to that date… what formula would be created? It would be marked "Closed" if completed and "Open" if not completed. Additionally when that item is passed the "due date" and still "Open" we would like to count the amount of…
-
RankEQ formula by group
Hi, I'm hoping to make the RankEQ formula have a criteria component to the ranking to rank overtime on deck per shift instead of by the whole group. We keep all the information on a larger spreadsheet and have a ranked report available to all staff. The column headers are below: Thanks for any help!
-
Formula to Use a Date Field and add a Number Field to return new Date
I want to use a calc on a date field, to use one date field and add a number value field to return a new date in the field with calculation. I am using =parent([SOO Start]@row+[SOO Day Duration (Calc'd 25%)]@row But I get an #Unparsable error in the field. The field I am entering calc on is a date field, [SOO Start] is a…
-
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…
-
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…
