-
Return Text that is in a Data/Number Column that captures dates
In the table below, I have 3 columns that are text/number fields: Final Document, Target Date, Actual Date. In the Target MM/YYYY and the Actual MM/YYYY, I have a formula to pull the MM/YYYY from the Target date and Actual Date, but as you can see, there is "On Hold" and "Cancelled" text instead of a date in some of the…
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
Color code drop-down lists in calendar view
Hi all, I am new to Smartsheet and I hope you can help me with a question. This is my current sheet set up to keep track of the events organised by my team organised by country. Each country is a Parent row and child rows are the events' names. I would like to format it in such a way that if the parent row is color coded…
-
countifs and a date that falls between two dates
Please help! I have two formulas that I am struggling with. I am trying to count how many tasks have been completed/closed within the past fortnight. I came up with the following formula but it gives me the 'invalid operation' error. What am I doing wrong? Formula=COUNTIFS({LV_ BLD CONST QUERY REGISTER _status}, "closed",…
-
Formula to check a box based on two conditions
I have a sheet with a client name on the sheet 1. I want to check a box on sheet 1 based on the values on the CRM sheet. If the CRM sheet has the client name on sheet 1 and the offer status column is "Accepted" on the CRM sheet, I want to check a box on sheet 1 next to the clients name. They may be listed in the CRM sheet…
-
Need someone's logical brain on a formula
Hi all, I need help fixing this formula: =COUNTIFS({TGN Bluesheet Tracking List Range 4}, =DATE(2023, 6, 20), {TGN Content Range 2}, =AND("Facebook" "Instagram" "Threads" "X" "YouTube")). I'm trying to pull the number of a specific dropdown list from a specific date. Any ideas on the best formula?
-
Updating Project Stage Advancement formula
We have a current formula for Project Stage Advancement, that updates the Project Stage field when all tasks under in the section have been marked 100% and a task in the next section has been marked In Progress. =IFERROR(INDEX([Task Name]:[Task Name], MATCH(MAX(COLLECT([Start Date]:[Start Date], Status:Status, OR(@cell =…
-
Looking to Resolve #NO MATCH with a Multi-select Dropdown
I've tried many variations and got very close with: =IF(CONTAINS("Orientation", Course@row), INDEX({Course Start Date}, MATCH(Course@row, {Courses Dropdown Name}, 0)), "") - it only pulls when there is one selection provided in the multi-select dropdown and a "#NO MATCH" where there are more than one course selected. We…
-
JOIN with 2 columns that are NOT next to each other, and "force" order
I am (trying to) using the JOIN function. It works but NOT the way I want it to. First, the columns I wanted to join were not next to each other. I am attempting to join 2 columns in a specific order and NOT the column in between. What am I doing wrong? They need to be in this order as the essential piece of data is the…
-
How to use automation to copy only certain rows to another sheet?
I have large rows of dataset in a sheet. I am looking for a solution that can copy specific rows to another sheet based on certain criteria. I used the automation template for copying rows, however, on fulfilling the condition specified, the automation all rows in the primary sheet to the secondary sheet. Is there a way I…