-
Hyperlink to a server (referencing cells that tell it where on the server it is)
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team. But it's 2…
-
Checkbox in Column if RYB is Red or Yellow, Not checked if Green in Risk Column
Hello, I am new to using formulas and am struggling with trying to automatically check a checkbox in one column if, in the Risk column, the RYG risk is red or yellow, not checked if risk is Green. I am able to get the following formula to work for red and yellow: =IF(OR(Risk1 = "Red", Risk1 = "Yellow"), 1, 1) I am not able…
-
Wanting to pull "today's data from a column
I have a spreadsheet has data related to customers orders by accounts, status and dates. This spreadsheet feeds a roll up sheet that rolls up the information from the base spreadsheet. I then take that data to feed a dashboard. I need a formula I can put into the roll up sheet that pulls all the orders that are scheduled…
-
Populate a drop down based on date in other columns
Is it possible to auto-populate a drop down based on a date being entered over a range of columns? Example: Column 1 (Drop Down) Pending (Date) Review (Date) Released (Date) Pending 2/21/19 Review 2/12/19 2/19/19 Released 2/12/19 2/19/19 2/21/19 So what I am looking for is if there is only a date in Pending, then Pending…
-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
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
-
Help! Trying to edit the automation of RYG balls!
Hello All! I am stuck trying to fix the automation of my RYG balls in Smartsheets! I need to add one more IF formula to be the formula below so that if a task has not yet been started, the ball will show up as gray. You can see from the screenshot below that all the other balls are working except when the task has yet to…
-
Weeks Out - Production Timeline Templates
I'm trying to replicate a function that is helpful for creating production timeline templates, that I use in google docs. Column A is the due date of a task. Column B is the number of weeks out from your launch date. Column A is calculated by taking your launch date and subtracting the weeks out, to create a due date for…
-
Count Ifs giving error
I've created the following cross sheet CountIfs formula: =COUNTIFS({Hutto NA Status}, "Done", {Hutto NA Owner}, [Primary Column]15, {Hutto NA Date}, >TODAY(-7)) Each segment works perfectly on its own but when I combine them, I keep getting an #INCORRECTARGUMENT error. I'm not sure what the issue is. Appreciate anyone's…
-
Monthly Turnover Time
Hello, I am working to create a widget on a dashboard. In order to do this, I want to get data between a start date and end date (turnover time) per month to show monthly progress. I have tried by finding the month and year but I'm not sure how to attach the turnover time days with its corresponding month/year . . .…
