-
Auto format drop down menu
Hello everyone, I am trying to set an auto format for drop down menu to give select options from another column's drop down menu. Does anyone know how I can accomplish this? Example: If Assignment is Compliance give me the 5 specific compliance options from a list of 20 on another column. Thanks in advance,
-
Sharing Question -
A workspace was shared with me, and I was made an editor who can share. For a specific SmartSheet in a subfolder underneath that workspace - how do I request to the owner that I want to be an admin of that SmartSheet in order to set up conditional formatting, send automatic alerts, etc.? I do not see any option of making a…
-
Highlight Recently Modified Fields
Is it possible to create a condition that highlights only those fields that have been modified within a specific date range? I would like the highlighting to appear the way the notification email exclusively highlights new or changed fields.
-
VLOOKUP and Conditional Formatting
I updated our smartsheet team schedule to grab dates from my department's master schedule. However, the conditional formatting we set up that visually shows us when a project is nearing or past its due date no longer works on the VLOOKUP cells Is there something I'm doing wrong? Or is this a limitation of the software? Has…
-
Calculating a date from another date in same row
how do I have the start prepping date calculate off the meeting date automatically in the same row. ie I have a meeting on 1/22/18 and I need to start planning 10 weeks prior and would like it to be automated. The problem is this is a major calendar for over 30 meetings, and all have different lag times for planning. I…
-
How to change row formatting based on a single cell?
I am trying to create a list of design standards and have a drop down list in a column that associates each row to a different project type: Affordable, Market, Selling. I'd like to be able to have the first row be a control that sets criteria for the rest of the sheet or a specific column. Thus if I select "affordable" in…
-
Is there an "OR" condition in conditional formatting?
I'm a very new user (1 week) and I am trying to apply conditional formatting if any one of 4 conditions is met. I need an OR statement but can't figure out how to do it, other than to do a separate rule for each condition. I searched the community and help and couldn't find anything about OR conditions. Thanks!
-
Changing Row Status
Hi there, My ultimate goal is to capture the "latest" entry from each row. This information will feed into another sheet/Dashboard. The column names are shown as dates Jan 7, Jan 14, Jan 21 etc... but, are formatted as text/number columns (not date columns). With that being said, Is there a way to automatically change a…
-
RYG formula not working
I have been researching formulas trying to find solutions without having to tap into the community and duplicate my question with others, however, I really am stuck. Trying to create a formula for RYG based on planned finish date and status. Here is what I wrote - unparsable is the error. Are there supposed to be spaces…
-
Conditional Formatting - Not working for updates / new cells
All of a sudden conditional formatting (colors) of cells when a specific list option is selected on a cell update or when a new row + cell is created. The conditional formatting rules are working for existing cells, but not for above. I've tried deleting the rules and re-creating them, clearing formatting in the column,…
