-
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…
-
Filter "is one of" drop down lists
Is there a way to clean up the drop down list on "is one of" filters? They still contain items that have been totally deleted from the column being filtered. This is very confusing to users. Thanks
-
Customizing Reminder message
I have a sheet where I log our employees training. I set up a calculated date column where I add 60 days to their training renewal date. I want to setup a reminder telling me that such employee need to renew his training within the next 60 days. How can I customize the reminder message so it's shows me this employee and…
-
Magazine Project Sheet?
My department manages the production of a quarterly magazine and uses SS for the editorial/content management process. Here is the sheet we currently use: https://publish.smartsheet.com/c95e42926fad4be7ae3463eaf2b228da I'm wondering if this seems like the best process, or if there's a simpler solution to a project that…
-
Conditionally move rows with Zapier and a check box
Hello all, I would like to automate my time sheet approvals. I use the professional plan with zapier, which does allow multiple steps. I am trying to conditionally move a row when a check box is checked in the "approved" column. However, I cant figure out how to enter the selection criteria in the "custom" value portion of…
-
Linking pages
Hey Guys, i am looking for a way to have vital data show up from one sheet onto another. I am using 6 sheets to keep track of project data. Each individual line in the sheets has all of the data for one project. In this line is a check box that states "Ops Scheduled". I need a way to have projects lines that do not have…
