-
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…
-
How to display Days Elapsed only if Status is Open?
Like the title says, I'd like to only show the number of days elapsed when the status is on Open. I'm currently using this formula: =IFERROR(NETWORKDAYS([Report Date]@row, [Due Date]@row), "") Any tips would be highly appreciated!
-
Conditional Formatting Based on 2 Date Columns, with or without Helper Column
Hi! I've scoured the Community posts, and can't find exactly what I need. I am managing a membership list and need to flag when memberships expire before or on a specific date (06/29/2023) so I can contact those members. I have one column with their membership expiration dates, a second column with the 06/29/2023 deadline,…
