-
Conditional Formatting
Hi, I need to apply conditional formatting based on another row in the sheet. Higher it should be highlighted in red, equal to or below highlighted in green. It would be easy to just use the target figures in the conditional formatting rules but I need to be able to change it frequently without changing all the formatting…
-
If Imported File Contains the Same Value in a Field Multiple Times Automatically Create Children
Okay. This is super hard to explain. Here it goes, I will be importing an excel file to smartsheet through zapier. One header field is called "Reference". I will be importing orders, and how it exports into Excel, each individual product on ONE order will have the same Reference number. For example, 5 rows might say…
-
Countif date is in the next 30 days
Can a COUNTIF (or other formula) count if a date is in the next 30 days or is in the past compared to the inspection date? I have conditional formatting flagging this, but would also like to count how many date violations there are as I will eventually add more expiration date columns. I have only been able to figure out…
-
Automatically Delete Attachments when a condition is met
To save on storage space, I would like to automatically delete attachments to a row when a condition is met, as I would no longer need to reference those. Thanks!
-
How to return most recent value when conditions met. Smartsheet Support is Stumped
Hello, I stumped Smartsheet Support with this formula question: I want to return the most recent approval status from another column based on common Project ID. I have four columns: Created Date - Project ID - Enter Status - Project Approval Status (Where the formula exists) All the columns are text except for Created…
-
Conditional Formatting activating incorrectly
Please review the following Screenshot. I can confirm that all columns are empty except for the one cell with "Yes" in the column highlighted in yellow here. I have a series of Conditional Formatting that would highlight the Responsible Contact Field for a group of important fields. However, the Mexico Field that is…
-
Basic A/P and A/R payment tracker
We're a property management company with a construction arm. Our construction is basic and requires us simply to track Owner/Address/Date of approval/Job number (which we create)/Contractor's Bid/Change orders/Payments to Contractor/Balance to contractor/Our Bid/Change Orders/Payments to us/Balance due us/A/R for cash paid…
-
If Box is checked change priority to blue
How can i setup this scenario: I have one column with Priority and one column with checkboxes. I would like it to change the priority to blue (from red, yellow, green) if i check the box. I cant do this with conditional formatting, but maybe a formula can?
-
Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…