-
Using a VLOOKUP and IF statement to return different values based on two different columns
Hi, I'm so sorry if this kind of question has been asked in the community forum but I've been trying to comb the questions but haven't had any true luck yet. Currently I used a VLOOKUP function to populate a personnel contact column based on a particular project column. That part is working correctly. However, recently I…
-
Parent Flagging based on Child Rows
Hello, I'm working in a project planning trying to highlight if a specific row, or project, has any task as children that is at risk. Does any syntax support this function?
-
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?