-
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…
-
Check the box if it's a Monday
I have a [Due By] date column and a [Monday] checkbox column. I'm trying to create a formula that will check the box on any [Due By] that is a Monday. I got as far as getting the box to check if today is Monday: =IF(WEEKDAY(TODAY()) = 2, 1, 0) But can't figure out the rest. Thanks for your help!
-
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…
-
Request type by project
Hello, I'm having difficult trying to report on metrics that would outline the following: Identify the number of request types by project For example, if you have 5 projects, all named differently and 2 request types (new/existing) and you wanted to report in a sheet, to then carry over to a dashboard the number of…
-
Cross-sheet formula
I would like for sheet to auto populate certain fields based on entering in a "property name" When I enter a property name, I would like for it to access the fields from another sheet that has that property name, and input values for that property. would I use a =vlookup? Thanks for you help! SGF
-
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…
-
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…
-
Counting summary data by week and month
I'm collecting data on number of inspections conducted each day, and would like to calculate summaries for each week and month. I've figured out the month formula, but struggling with how to do this for each week. I think I need to create a formula that specifies the date range for each week (though if this could be more…
-
Parent/Children Formulas with Date Ranges
Hello, Can I get some guidance on how to properly use Parent/Children formulas for a Summary sheet that is fed by information from a reference sheet? I have several count ifs, and sum ifs all corresponding to the month and the year. The parents and children will all have the same metrics and hierarchy for multiple…
-
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…
