-
Date Range Validation
Based on a few suggestions and other references I calculated a dollar value using the following formula: =NETWORKDAY(DATE(2023, 7, 1), DATE(2023, 7, 31)) * [Hourly Rate]@row * [Hrs/week]@row / 5 It works well, but I'd really like the formula to reference two separate columns: Start Date and End Date so the column won't…
-
Vlookup as "Column Formula" is not working properly
Hello! I was hoping someone can please point me in the right direction on this one. I created a Vlookup that will compare an ID number on a sheet that users will fill out via form, and return the due date listed on a different spreadsheet. The formula I created worked on the first row. =VLOOKUP([Context ID]@row, {Due…
-
If then greater than or equal to....
I am working on a task list that will return green, yellow, or red based on criteria with today's date and the due date. Everything appears to be working unless the total equals the today - the due date + 7. I have this column formula and one cell will not work correctly. Help! =IF(TODAY() - [Due Date]@row < 0, "Green",…
-
Formula help to calculate annualized specific to a specific starting month
I have a formula working correctly, (thanks to Paul Newcome) where a month is entered and an amount (Annualized Project Impact ($)) which then populates to the correct months, based on that start date then carries across the remaining months. Here is the existing formula for that =IF(MONTH([Planned Project Savings Start…
-
How to update info from multiple sheets to one master log?
Good evening. I am working on setting up Smartsheet to track engineering information for my company. Each branch has it's own sheet and one person responsible for logging data into this sheet. That data is then copied to a "Master" sheet for company-wide comparison. Most of the information is known at the time of input,…
-
Using COUNTIF with IF(AND
Hi! I'm fairly new to formulas and not sure where I'm going wrong here, any help or insight would be greatly appreciated :-) - thank you! I'm trying to say, in a Metrics sheet, "please count this status if it is "Not Started", checked as active (it's a checkbox column), and says "Near-Term" in the drop-down field in that…
-
Trying to find the percentage of time that a word appears in a column.
I have a column with Red, Green and Yellow but I want to find the percentage of times the word Red is used. I tried =COUNTIF([All screeners present at event]:[All screeners present at event], "Red"), /COUNT([All screeners present at event]:[All screeners present at event])) but I'm getting an error
-
IF cross-sheet formulas with conditions
I'm working in a sheet column and trying to pull data from another sheet BUT pull data from two different columns based on IF this row matches data in another column. Here's the current formula that only pulls "Schedule Notes" from another sheet when it matches the Course Numbers. =IFERROR(INDEX({Course List Worksheet -…
-
Monthly Calculation
I need to calculate monthly expenses but I've managed to stump myself on the formula/function. Here is my use case: I've got individual line items by user, but I want to sum their monthly expense by month. I have a range the individuals are contracted with us...say from 7/1/2022 to 5/31/23. How could I write the formula to…
-
Cross referencing multiple forms using a formula?
Hello there, I have a destination sheet, where I need to reference 3 types of data from 2 other support sheets that I have made. Those are (cost of airfare, date travel was booked, and cost on non-airfare). One of the support sheets has a form that will record airfare cost, and travel date booked from recipients. The other…