-
Conditional formatting based on time from today
I want to create conditional formatting rules on a Date column and cannot figure out how to enter Today in the criteria Example: Select column = EOL Date is < TODAY = Red is between TODAY() and TODAY() + 180 = Yellow is > TODAY() + 181 = Green I can do it in Excel just fine but when i enter TODAY() in the criteria it says…
-
Conditional lock
Hello, I am trying to develop a shareable sheet in which some tasks are listed along a row and check boxes are used to indicate a task has been completed. Would it be possible to lock these checkboxes if its previous one haven't been checked? In this way a process flow would be enforced. Perhaps the solution would include…
-
Expand Project Row
Hello, I would like to know if you are able to expand a row into a dashboard view. For example, if one row shows a project I am working on, and I have included several notes.. is there a way I can blow it up into a quick view of all items of included in the row (notes, dates, etc.). I would like to show/send the project…
-
IF formula help to gray out a status
Hi Community...having issues with this formula working for the "Gray"Status. The other criteria is working so can't figure out why I can't get gray status to work. =IF([Actual Progress]10 >= ($[Week 1 Target Progress (Aug 22)]10 * 0.8), "Green", IF(AND([Actual Progress]10 < ($[Week 1 Target Progress (Aug 22)]10 * 0.8),…
-
Formula Help
I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn the Status Column drop down to red. Once the Status Column drop down is changed to green…
-
Editing Conditional Formatting Rules
Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column 2 is 'in the past' and column 3 is 'blank' and column 4 is 'not blank', and i wanted to…
-
Can you do if this then that for auto entry from drop down list
I want a column to chnge its value from a drop down list when a criteria is met. What I am after is a column that is titled "ready for invoice" and is a check box. I have another column named "currently assigned to"that shows the seperate departments on an account and it reflects which department is resposible for the…
-
Auto Assign w/in Marketing Request Tracker
I am trying to figure out how to write a formula to auto assign a task when it meets different criteria. For example, my column is "Type of Request". If it is Creative, then I want to assign Kristi from my contact list. If it is Product, I want to assign John. I have 7 different choices within the Type of Request column…
-
Auto-filling columns in Smartsheet
I have created a form which captures computer name, name, and email address of the person on the smarsheet in addition to the other data they are submitting. Is there a way I could use the formula to auto-fill name and email address for repeat users referencing the machine name either on the form or on smartsheet?
-
Doing things first time right with data validation
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "text…