-
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!
-
New Formulas Feature: Reference Data from Other Sheets!
You can now reference data from other sheets in formulas! Create a master lookup table sheet and use VLOOKUP to find data on another sheet. More information on this new feature is available in our help center: https://help.smartsheet.com/articles/2476606-formulas-reference-data-from-other-sheets
-
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…
-
Conditional formatting font color in Card View
Is there any way for font color changes via conditional formatting to be shown on the cards? I have a formula the changes the row's font color red when an end date field is in the past. Unfotunately I can't see these changes in card view, only in grid. Thanks for the help!
-
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…
-
Smart Header Rows - Feature request
Header Rows that group and/or describe the rows beneath them are very useful (especially in to-do lists) but they could be better in a couple of ways: 1. Allow users to designate rows as 'header rows' that are exempt from conditional-formatting, auto numbering and date-created fields, etc. 2. Allow a line's postion…