-
Filters for different users
hi Im a new smartsheet user and need some help! we have a sheet with a work schedule. There are address/information columns and then columns of dates for various contractors. We would like to give view only access to subcontractors but only want them to see their own columns. We want them to be able to access this…
-
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…
-
Calendar View
My conditioning format does not show when I view my smart sheet in the "calendar view". Any suggestions?
-
Automating RGYB Balls With Date Ranges
I want the status balls to automatically update based on the due date - but I also want the status to go blue after the "Item Completed" column is checked. Ie. If End Date is in the past, or due within the next week = Red If End Date is Due within the two weeks = Yellow If end Date is Due in three weeks or more = Green If…
-
This rule triggered itself directly or by at least 1 other rule, which is prevented.
I have a SmartSheet constructed as follows: 1. A dropdown list contains five options to indicate the task status (Column = "Pickup Status"). Pickup Status Pending... Pickup Now Do NOT Pickup Pickup Completed Unable to Pickup 2 . The Foreman will use a form to submit the initial data and set a hidden field to "Pickup Status…
-
Conditional Formatting Not Working
Hello, I've set my CF rule to look like the screen shot I have attached. I've been over it for what seems like 100x but it's just not working. Can someone please help?
-
Notification Dates
Is there a way to edit the dates for when to set a notification past 14 days? We are looking at a way that this can be edited when we need notice 3 weeks in advanced or any specific number of days.
-
Formating for dates past
I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? any help welcome. thanks G
-
Feature request - dynamic lists
Dynamic lists would be a very valuable feature in smartsheet. When we add a new employee to our system, we need to add them into about 10 different sheets, so that they can select their name from the relevant lists and fill out a timesheet, project reporting etc. If the new employee could be just added to a dynamic…
-
Formula / Multiple Sheet Reference Assistance
Hello! I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project. I have one column that uses a VLOOKUP to…