-
Countifs function when using multiple contacts in a cell
Hello, I am trying to run metrics on assigned tasks that are assigned to people on my team. I have reports that will pull into each person's task report even with multiple assigned contacts in a cell, but when I do COUNTIF for a specific person's task, it does not count because there are multiple contacts in a cell.…
-
What is wrong with my formula?
Hi all, I'm trying to write a formula with the following conditions to get the % Complete Complete - 100% N/A- 100% Outstanding - 0% Partially Complete - 50% for example, if we have 4 tasks - 2 of them are N/A and 2 of them are complete - it should be 100% since N/A and complete acts as 100% if we have 2 partially complete…
-
RYG status set by % Complete and End Date
I am using a Smartsheet template (Project Tracking Template) and it comes with RYGB statuses. I would like to only use RYG and adjust the formula but am failing miserably. Please help!!! Here's what I'm trying to accomplish: Green = If % complete is 100% or if end date is greater than today Yellow = If % complete is not…
-
Date Comparison Formula Help
I am a SmartSheet novice, but my team is used to base tracking in SmartSheet. I would like to set up conditional formatting that highlights if a site's planned schedule puts the site at risk. I would like to compare two columns: "Construction Schedule: Turnover to Retail Date" against "Exterior Installation: Scheduled…
-
Merged: Formulas in automation
This discussion has been merged.
-
Change 'Status' Column based on date past
Hello, I've searched for this a few times but cannot find a solution that fits what I require. I am trying to update a status column to show 'Being Reconciled' when a date column is in the past. The automation feature doesn't seem to work unless rows are being manually changed. I've created a helper (=IF(TODAY() >…
-
Formula to Handle SLA Due Date vs Campaign Start Date
Hi, Smartsheet Community! 👋 This is my first post. Thanks in advance to anyone offering help. Much appreciated! Lots of text ahead but I'm trying to include all relevant details and context. SITUATION We recently launched a new digital marketing request form. On the request form, there are fields for Campaign Type and…
-
True value if during the last 12 months
Hi all, I keep getting turned around in trying to build a formula to return a true value if the year/month is within the last 12 months. What I would like to do is check off which rows should be included in the rolling report so that as the year goes on, the last 12 months are always checked. Anyone have any thoughts on it?
-
COUNTIFS formula looking at date columns in a reference sheet
I used the Inspection Tracking template set a base. I liked it as a starting point, and added expiration dates. Looking at the metrics sheet provided, it uses this formula to look at the number of violations per month. I also want to see the number of date violations that occurred per month. Date violations would be…
-
How to change cell value from another sheet
Hello! Basically, I have an automation set up to send anything that is on Backorder (when B/O is checked) copy it from my "Open Orders" sheet to my "Backorder Clip" sheet. I have two questions regarding this. How do I set a formula that will apply any changes made to my "Backorder Clip" sheet rows will automatically update…
